<?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 How can we create dynamic partitions in Hive external table.? in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/How-can-we-create-dynamic-partitions-in-Hive-external-table/m-p/124821#M87565</link>
    <description>&lt;P&gt;Hi, i created an external table in HIVE with 150 columns. i have a .csv file for each day , and eventually i will have to load data for 4 years.&lt;/P&gt;&lt;P&gt;i just loaded one month worth of files which turned into 2mill rows.&lt;/P&gt;&lt;P&gt;i now like to partition the table by date (which first column in the table and file).&lt;/P&gt;&lt;P&gt;1.how can i partion on existing table and 2. can i do it dynamically when i load other files.&lt;/P&gt;&lt;P&gt;Regards,Sai&lt;/P&gt;</description>
    <pubDate>Wed, 11 Jan 2017 23:37:37 GMT</pubDate>
    <dc:creator>saikrishna_tara</dc:creator>
    <dc:date>2017-01-11T23:37:37Z</dc:date>
  </channel>
</rss>

