Hive and Impala working together.This blog teaches us how we can view tables in both about each other.
As Hive metastore is getting into the center of nervous system for the different type of SQL engines like Shark and Impala. It getting equally difficult to distinguish type of table created in Hive metastore. Eg. if we create a impala table using impala shell you will see the same table on hive prompt and vice versa. See the below example
Step 1 : “Create Table” in Impala Shell and “Show Table” On HIVE Shell
Step 2 : “Create Table” in Hive Shell and “Show Table” On Impala Shell
Step 3 : Invalidate Metadata on Impala Shell ( This may not be needed always )
Step 4 : “Show Table” On Impala Shell
In short this proves that tables are visible in both shells. Use describe formatted <table name> command to find out the details. Storage Desc Params will show a value “serialization.format” for hive table, where…
View original post 41 more words