You could do something like that. However you can structure the table as:
CREATE TABLE X ( Map stuff)
CREATE TABLE X ( List stuff)
You can then define a viww over these structures that allow you to
cherry pick the fields you want.
Edward
On Tue, Mar 13, 2012 at 1:03 PM, Keith Wiley wrote:
> Wra
Wrapping hive around existing csv files consists of manually naming and typing
every column during the creation command. I have several csv tables and some
of them have a ton of columns. I would love a way to create hive tables which
automatically infers the column types by attempting various
