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.