Support Questions

Find answers, ask questions, and share your expertise

Data is not loaded in hive using “Hive warehouse connector”

I used the below command to connect Hive Warehouse Connector.

spark-shell --jars /usr/hdp/current/hive_warehouse_connector/hive-warehouse-connector-assembly-

Then I executed the below query to create a table

>>> spark.sql('create table C_DAMAGE_join stored as orc as select tdc.* from T_DAMAGE_CODE CD LEFT JOIN C_DAMAGE TDC ON CD.ID = TDC.DAMAGE_CODE_ID')

Now the issue is table created in hive with only metadata , without any data.


Cloudera Employee