Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

SQOOP IMPORT --map-column-hive ignored


Hello guys,


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.

Who agreed with this topic