Sqoop imported hive field names from mysql, sqoophive

Sqoop imported hive field names from mysql, sqoophive

There are some keyword restrictions in hive, so some field names are available in mysql, but it won't work when it comes to hive.

For example, order must be changed to order1. The following lists some of the field names we found that cannot be used in hive.

Order => order1

Sort => sort1

Reduce => performance1

Cast => cast1

Directory => directory1

How can I not query sqoop data imported to hive tables?

Where do you enter the sqoop import directory? If you enter the command in/usr/sqoop, enter hive in/usr/sqoop and then show tables to view the command.
 
Can hbase imported by sqoop be used directly? Or do I need to see the table in hbase and insert the imported data?

A simple command is enough.

Sqoop import -- jar-file (your jar package) -- class-name (classname) -- connect (mysql instance) -- username (username) -- password (password) -table (table name)-hbase-table (hbase table name)-column-family (familyColumn)-hbase-row-key (hbase rowkey) -- hbase-create-table