thiverow error

[DrGenious]

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.

[manodwhb]

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

[DrGenious]

@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) ? 

[manodwhb]

@DrGenious ,check the below links.

https://docs.qubole.com/en/latest/connectivity-options/partner-integration/talend_integration_guides...

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

[DrGenious]

@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.