topic Re: thiverow error in Talend Studio

thiverow error

DrGenious — Wed, 04 Mar 2020 10:21:42 GMT

Hey ,

I am trying to insert values with thiverow into my table in hive and when I parse a row with less columns it throws an error. Is there any option to assign with NULL value the empty columns? Also I tried to parse with thiveload but it throws me an error :

//ParseException line 1:26 cannot recognize input near 'INSERT' 'INTO' 'TABLE' in statement

My statements is "INSERT INTO TABLE test VALUES ('1','2')"

Thanks a lot.

Re: thiverow error

manodwhb — Thu, 05 Mar 2020 04:01:02 GMT

@DrGenious , there is no option to set that , you need to write query and call that in tHiveRow.

Re: thiverow error

DrGenious — Thu, 05 Mar 2020 05:09:23 GMT

@manodwhb thanks for your answer.

In what component to write the insert query and also how to call the query to thiverow?

Now that I want to parse my rows from a file into hive table is there any option to understand the query INSERT INTO TABLE ...VALUES (input_row.id, input_row.name) ?

Re: thiverow error

manodwhb — Thu, 05 Mar 2020 12:24:45 GMT

@DrGenious ,check the below links.

https://docs.qubole.com/en/latest/connectivity-options/partner-integration/talend_integration_guides/talend7.1_integration/configuring_hive.html

https://saagie.zendesk.com/hc/en-us/articles/360007829959-Query-Insert-from-Hive

Re: thiverow error

DrGenious — Mon, 09 Mar 2020 05:26:26 GMT

@manodwhb

Ηι,

I managed to parse a file into hive with global variables in the INTO statement. Although when I am trying to parse a file through tWaitforfile component it throws me an error.

[ERROR]:table_0_1.test_table - tHiveRow_2 - Error while compiling statement: FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type . not supported in insert/values.