Hi My data is in the value field of a sequence file. The value field has subfields in it. I am trying to create table using these subfields. Example: <KEY> <VALUE> <KEY_FIELD1, KEYFIELD 2> forms the key <VALUE_FIELD1, VALUE_FIELD2, VALUE_FIELD3>. So i am trying to create a table from VALUE_FIELD*
CREATE EXTERNAL TABLE table_name (VALUE_FIELD1 as BIGINT, VALUE_FIELD2 as string, VALUE_FIELD3 as BIGINT ) STORED AS SEQUENCEFILE; I am planing to a write a custom SerDe implementation and custom SequenceFileReader Pl let me knw if I am on the right track. -Sagar
