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.

Reply via email to