About carlospascual92

carlospascual92 · ‎12-11-2017

I think I didn´t explain my problem well. Apologies in advance. I will try to explain it well. I have the next table: create table test1(name string, age int, dept array<string>) row format delimited fields terminated by ':' collection items terminated by ',' stored as textfile; Now, I load this next file: a:25:sales,marketing b:26:dev,qa With this file loaded, I want to update the table so that, for example, in the first line the array dept is [marketing, FINANCE]. I mean, I want to add a new value in this array. Thank you in advance.

carlospascual92 · ‎12-11-2017

Thank you so much!

carlospascual92 · ‎12-08-2017

Hi! I have created a table in hive like this: create table if not exists TablaCatalogo1 (name string, species string, varietal string, provenance string, toast string, process string, formatt array<string>) row format delimited fields terminated by ':' collection items terminated by ',' lines terminated by '\n'; in which formatt is a array of string. Now, I want to insert a new value in this array for a certain product. I tried to use a dummy table to insert the value but I didn´t get. Any way to do it? Thank you so much.

Online	Offline
Last Visited	‎12-11-2017 11:22 AM

Member Since	‎12-08-2017 11:12 PM
Last Visited	‎12-11-2017 11:22 AM
Posts	3

Cloudera Community

Re: insert complex data in hive table

Re: insert complex data in hive table

insert complex data in hive table