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

[#1]

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.

[#2]

@Deb This doc will help you https://docs.hortonworks.com/HDPDocuments/HDP3/HDP-3.0.1/integrating-hive/content/hive_hivewarehouse...