01-10-2016 02:47 AM
I was following the 'Ingest and query relational data' tutorial on CDH 5.5. I tried executing this command:
sqoop import-all-tables \
-m 1 \
--connect jdbc:mysql://quickstart:3306/retail_db \
I get the message that the job is successful. But I am not able to see the tables in Impala browser. I can even see all the files created under the /user/hive/workspace. But I am not able to see the table.
Thanks in advance for the help!
01-10-2016 06:33 PM
01-20-2016 01:23 PM
I also tried to acces the dataset for the following schema
I also tried "invalidate metadata <tablename>" but it didn't find any table.
I am running cloudera quick start VM 5.5
05-24-2017 03:14 AM
Just need to add --hive-import to the end of your script/commands
then in Imapa just run :
invalidate metadata; show tables;
work for me :)
03-15-2019 04:58 AM
If you want to manipulate the table through Impala-Shell then you only need to run the following command from a pc where Impala is installed.
impala-shell -d db_name -q "INVALIDATE METADATA tablename";
You have to do INVALIDATE because your table is new for Impala daemon metadata.
Then if you append new data-files to the existing tablename table you only need to do refesh, the command is
impala-shell -d db_name -q "REFRESH tablename";
Refresh due to the fact that you do not want the whole metadata for the specific table, only the block location for the new data-files.
So after that you can quey the table through Impala-shell and Impala query editor.