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
Last activity: Apr 16, 2019, 03:31 PM