This SerDe adds support for reading pg_dump plain ouput. It does not support skipping header/footer lines. Header/footer data will have to be manually removed. Other alternative is to use COPY
command to generated text format output.
hive> add jar path/to/pgdump-serde-1.0.4-1.2.0-all.jar;
hive> create table my_table(a integer, b string, ...)
row format serde 'com.pasam.hive.serde.pg.PgDumpSerDe'
stored as textfile
;
Run mvn package
to build
Run mvn eclipse:eclipse
to generate .project
and .classpath
files for eclipse
pgdump-serde is open source and licensed under the Apache 2 License