Concat_ws not working in insert statement in hive

Question

Using hive, I'm trying to concatenate columns from one table and insert them in another table using the query

insert into table temp_error 
select * from (Select 'temp_test','abcd','abcd','abcd',
from_unixtime(unix_timestamp()),concat_ws('|',sno,name,age)
from temp_test_string)c;

I get the required output till I use Select *. But as soon as I try to insert it into the table, it does not give concatenated output but gives the value of sno only instead of whole concatenated output.

can you provide the "desc temp_error;", "desc temp_test_string;" — Nirmal Ram, Nov 22 '16 at 05:51
and also a single row of what you get when you give "select *" and "insert into table" — Nirmal Ram, Nov 22 '16 at 05:53

score 0 · Answer 1 · answered Nov 23 '16 at 12:18

0

Thanks guys. I found why it was behaving that way. It's because while creating table I gave "separate fields by '|'". So what I was trying to insert as a string into the table, hive was interpreting it as different columns.

answered Nov 23 '16 at 12:18

Shubham Venayak

41
6

Concat_ws not working in insert statement in hive

1 Answers1