I want to access individual columns from a table created with row delimited
by RegexSerde.
For example,
I have created a table as below:
create table test ( col1 STRING, col2 STRING )
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
WITH SERDEPROPERTIES ("input.regex" = "([^ ]*) ([^ ]*)",
"output.format.string" = "%$1s %$2s");
After loading valid data,
*select * from test* workd fine,
however *select col1 from test* or *select col2 from test* or *select col1,
col2 from test* fail.
how do I achieve the above.
Thanks,
MIS.