有人可以帮助在我的配置单元中获取'\ \ \ \'(四个反推)插入覆盖查询输出。
我试过了:
beeline = "beeline -u 'jdbc:hive2:blahblah'"
exportDir = " /dev/targetdir "
presql = ' INSERT OVERWRITE DIRECTORY \'' + exportDir + '\' ROW FORMAT DELIMITED FIELDS TERMINATED BY \',\' ' + 'ESCAPED BY \'\\\\\' NULL DEFINED AS \'\' '
sql = " select abc from xyz limit 10 "
>>> print(beeline + " -e " + '\"'+ presql + sql+'\"')
beeline -u 'jdbc:hive2blahblah' -e "INSERT OVERWRITE DIRECTORY '/dev/targetDir/' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' ESCAPED BY '\\' NULL DEFINED AS '' select abc from xyz limit 10"
#Expected O/p:
beeline -u 'jdbc:hive2blahblah' -e "INSERT OVERWRITE DIRECTORY '/dev/targetDir/' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' ESCAPED BY '\\\\' NULL DEFINED AS '' select abc from xyz limit 10"
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句