Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

New Contributor

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”

New Contributor