09-21-2016 05:25 AM
I am using Scoop to transfer data from postgresql to hive usaing storage parquet.
I have a problem with the postgresql format "timestamp without time zone" which is mapped to BIGINT and becomes unsable for queriing.
I found the import option: --map-column-hive varname=type.
I have tried with the type:STRING and TIMESTAMP, both are ignored and I do not get any message about it.
Version used: SQOOP 1.4.6, Postgresql 9.4, CDH 5.8.
any idea is welcome.