Sample Header Ad - 728x90

Change column datatypes in Hive database

3 votes
1 answer
10880 views
Can I change the datatype in Hive database? Below is a complete information about the same. I have a database named "test". It has a table "name". Below is a query I had used while creating a column in name table. create table name(custID String,nameValuePairs array>) row format delimited fields terminated by '/' collection items terminated by '|' map keys terminated by '=' lines terminated by '\n'; Now, I would like to change the datatype entry of column name "nameValuePairs". Currently the column nameValuePairs has datatype array>. Now I would like to change the datatype to array>.
Asked by Nitesh B. (593 rep)
Sep 9, 2016, 08:43 AM
Last activity: Apr 16, 2019, 03:31 PM