I used the below command to connect Hive Warehouse Connector.
spark-shell --jars /usr/hdp/current/hive_warehouse_connector/hive-warehouse-connector-assembly-220.127.116.11.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.