<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Re: Need to access hive ACID table using spark.sql using hwc in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Need-to-access-hive-ACID-table-using-spark-sql-using-hwc/m-p/407991#M252644</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/104568"&gt;@rdhau&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can go through the below Cloudera documentations completely to understand to work with HWC.&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.cloudera.com/cdp-private-cloud-base/7.1.8/integrating-hive-and-bi/topics/hive_hivewarehouseconnector_for_handling_apache_spark_data.html" target="_blank"&gt;https://docs.cloudera.com/cdp-private-cloud-base/7.1.8/integrating-hive-and-bi/topics/hive_hivewarehouseconnector_for_handling_apache_spark_data.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.cloudera.com/cdp-private-cloud-base/7.3.1/integrating-hive-and-bi/topics/hive-hwc-reader-mode.html" target="_blank"&gt;https://docs.cloudera.com/cdp-private-cloud-base/7.3.1/integrating-hive-and-bi/topics/hive-hwc-reader-mode.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.cloudera.com/cdw-runtime/1.5.4/hive-metastore/topics/hive_apache_spark_hive_connection_configuration.html" target="_blank"&gt;https://docs.cloudera.com/cdw-runtime/1.5.4/hive-metastore/topics/hive_apache_spark_hive_connection_configuration.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Chethan YM&lt;/P&gt;</description>
    <pubDate>Mon, 05 May 2025 13:31:26 GMT</pubDate>
    <dc:creator>ChethanYM</dc:creator>
    <dc:date>2025-05-05T13:31:26Z</dc:date>
    <item>
      <title>Need to access hive ACID table using spark.sql using hwc</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Need-to-access-hive-ACID-table-using-spark-sql-using-hwc/m-p/407977#M252641</link>
      <description>&lt;P&gt;Hi Team i want to acees the hive ACID table using the spark.sql but when i am trying that i am just getting the table columns noit the data, now i tried using HWC but i am not sure as its showing in the docs that LLAP deamon shold be there in order to work with HWC can anyoine help me i am using spark 3.2.1&amp;nbsp;&lt;BR /&gt;what is the correct way to acess the hive acoid table using spark.sql ?&lt;BR /&gt;what are the prerequsite in order to work with HWC?&lt;BR /&gt;can someone share a code sniped so that i can also access the hiv acid table using spark.sql ?&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;spark = &lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; SparkSession.builder.appName&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"ReadHiveTable"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; .config&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"hive.metastore.uris"&lt;/SPAN&gt;&lt;SPAN&gt;,&lt;/SPAN&gt;&lt;SPAN&gt; hive_metastore_uri&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; .config&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"spark.sql.warehouse.dir"&lt;/SPAN&gt;&lt;SPAN&gt;,&lt;/SPAN&gt;&lt;SPAN&gt; warehouse_dir&lt;/SPAN&gt;&lt;SPAN&gt;&lt;SPAN&gt;).enableHiveSupport()&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;.getOrCreate&lt;/SPAN&gt;&lt;SPAN&gt;()&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV&gt;&lt;DIV&gt;&lt;DIV&gt;&lt;SPAN&gt;df = spark.sql&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;f"SELECT * FROM &lt;/SPAN&gt;&lt;SPAN&gt;{table_name}&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;).show()&lt;/SPAN&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;/DIV&gt;</description>
      <pubDate>Mon, 05 May 2025 07:51:14 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Need-to-access-hive-ACID-table-using-spark-sql-using-hwc/m-p/407977#M252641</guid>
      <dc:creator>rdhau</dc:creator>
      <dc:date>2025-05-05T07:51:14Z</dc:date>
    </item>
    <item>
      <title>Re: Need to access hive ACID table using spark.sql using hwc</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Need-to-access-hive-ACID-table-using-spark-sql-using-hwc/m-p/407991#M252644</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/104568"&gt;@rdhau&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can go through the below Cloudera documentations completely to understand to work with HWC.&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.cloudera.com/cdp-private-cloud-base/7.1.8/integrating-hive-and-bi/topics/hive_hivewarehouseconnector_for_handling_apache_spark_data.html" target="_blank"&gt;https://docs.cloudera.com/cdp-private-cloud-base/7.1.8/integrating-hive-and-bi/topics/hive_hivewarehouseconnector_for_handling_apache_spark_data.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.cloudera.com/cdp-private-cloud-base/7.3.1/integrating-hive-and-bi/topics/hive-hwc-reader-mode.html" target="_blank"&gt;https://docs.cloudera.com/cdp-private-cloud-base/7.3.1/integrating-hive-and-bi/topics/hive-hwc-reader-mode.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.cloudera.com/cdw-runtime/1.5.4/hive-metastore/topics/hive_apache_spark_hive_connection_configuration.html" target="_blank"&gt;https://docs.cloudera.com/cdw-runtime/1.5.4/hive-metastore/topics/hive_apache_spark_hive_connection_configuration.html&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Chethan YM&lt;/P&gt;</description>
      <pubDate>Mon, 05 May 2025 13:31:26 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Need-to-access-hive-ACID-table-using-spark-sql-using-hwc/m-p/407991#M252644</guid>
      <dc:creator>ChethanYM</dc:creator>
      <dc:date>2025-05-05T13:31:26Z</dc:date>
    </item>
  </channel>
</rss>

