You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by pratik khadloya <ti...@gmail.com> on 2014/09/12 02:26:56 UTC

Hive import is not compatible with importing into AVRO format

I am trying to import data from a free form mysql query into hive. I need
the files to be as AVRO data files, but when i pass the --as-avrodatafile
option, i get a compatibility error. Is there a way i can tell sqoop to use
the avro file format?

$ bin/sqoop import -jt <jobtracker> --connect
jdbc:mysql://<mydbserver>*/*<mydb> --username
<dbuser> --password <dbpwd> --target-dir /user/pkhadloya/sqoop/mytable
--query “<my query> WHERE \$CONDITIONS" --num-mappers 1 --hive-import
--hive-table mytable --create-hive-table --as-avrodatafile


~Pratik