Support Questions
Find answers, ask questions, and share your expertise

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

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-1.0.0.3.0.1.0-187.jar

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.

1 REPLY 1

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

Cloudera Employee