topic Re: tHiveRow - getting missing EOF parsing error in Talend Studio

tHiveRow - getting missing EOF parsing error

Anonymous — Sat, 16 Nov 2024 11:06:28 GMT

I am storing the below in a context context.query1
"CREATE EXTERNAL TABLE IF NOT EXISTS " + "DF." + context.tableNm + "_" + context.Version + " (" + row4.QueryRow + " ) " + "LOCATION "+ " '/data/dev/datalake/hive/warehouse'"
+ "ROW FORMAT DELIMITED"
+ "FIELDS TERMINATED BY ‘|’"
+ "LINES TERMINATED BY ‘\n’"
+ "STORED AS TEXTFILE"
and in the tHiveRow component in the Query section I input
context.query1 and running but I am getting the below Error
Error while compiling statement: FAILED: ParseException line 2:1 missing EOF at 'ROW' near "/data/dev/datalake/hive/warehouse"
: d01_f.df_preing_createhivetable_0_1.df_createHiveTable - tHiveRow_3 - Error while compiling statement: FAILED: ParseException line 2:1 missing EOF at 'ROW' near ''/datalake/ODM/d_datafabric/hive/warehouse''
how to overcome this?

Re: tHiveRow - getting missing EOF parsing error

Anonymous — Fri, 14 Aug 2015 09:50:21 GMT

Hi,

"CREATE EXTERNAL TABLE IF NOT EXISTS " + "DF." + context.tableNm + "_" + context.Version + " (" + row4.QueryRow + " ) " + "LOCATION "+ " '/data/dev/datalake/hive/warehouse'"

Could you please try to use statement "CREATE EXTERNAL TABLE IF NOT EXISTS " + "DF." + context.tableNm + "_" + context.Version + "+ row4.QueryRow +" + "LOCATION "+ " '/data/dev/datalake/hive/warehouse' to see if it works?

Best regards
Sabrina

Re: tHiveRow - getting missing EOF parsing error

Anonymous — Sun, 16 Aug 2015 07:02:57 GMT

not sure but I think it was some copy/paste issue. and PARTITION BY comes first and then LOCATION