Best unofficial Apache Server developers community |
|
So i have external tables of tab delimited data. A simple table looks like this:
Now I'm adding another field to the end, it will be a comma separated list of values. Is there a way to specify this in the same way that I specify a field terminator, or do I have to rely on one of the serdes? eg:
(I'm assuming I'll need to use a serde for this, but I figured there wasn't any harm in asking)
posted via StackOverflow
|
![]()  
|
I don't know how to update an existing table to do that, but for creating a table; what you are looking for can be found, in depth, at http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL. A snippet from there
An example from our table creation is
The line from that you'd be looking for is the hth |