Hello, I am executing hive command as follows:

hive -hiveconf hive.cli.errors.ignore=true -v -S -f tables.sql 2&>tablesCZ.log

inside tables.sql is simple sql as following:
select min(INT_CURRENT_DATE), max(INT_CURRENT_DATE) from 
SYSTGXX.POS_T096132_STG_ORC_TMP;$
select min(INT_CURRENT_DATE), max(INT_CURRENT_DATE) from 
SYSTGXX.POS_T096152_STG_ORC_TMP;$
et cetera

In tablesCZ.log I encounter error like this:
select min(INT_CURRENT_DATE), max(INT_CURRENT_DATE) from 
SYSTGXX.POS_T096132_STG$
_ORC_TMP$
FAILED: SemanticException [Error 10001]: Line 3:57 Table not found 
POS_T096132_STG$

Seems hive is wrapping the lines in input .sql file and adding $ end of line, 
then it does not understand table name. Is it possible to set linesize to 
bigger one, so it does not wrap input from file?


Enviroment:
Sqoop: 1.4.6.
Hive: Hive 1.2.1000.2.4.0.0-169
HDP: 2.4.0
Hadoop 2.7.1
Hcatalog: 1.2.1
Hbase: 1.1.2


Thank you



Reply via email to