Hive Unable to insert values to an array column using insert

Question

Unable to append data to tables that contain an array column using insert into statements; 

the data type is array < varchar(200) >

With the help of JDBC, I am unable to insert values into an array column by values like :

INSERT INTO example.table (codes) VALUES (['m','n']);

does not recognise the "[" or "{" signs.

Using the array function like ...

INSERT INTO demo.table (codes) VALUES (array('m','n'));

I get the following error using array function:

Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values

Tried the workaround...

INSERT into demo.table (codes) select array('m','n');

unsuccessfully:

Failed to recognize predicate '<EOF>'. Failed rule: 'regularBody' in statement

How can I load array data into columns using jdbc?

Answer 1

make a dummy table which has at least one row.

INSERT INTO example.table (codes) VALUES (array('m','n')) from dummy limit 1;

hive> select codes example.table;
OK
["m","n"]
Time taken: 0.088 seconds, Fetched: 1 row(s)

Comments

hql execution error, do you mean have data in the dummy table?

---

Can you explain your query a little bit more?