<?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 Space occupied by Kudu partition in Archives of Support Questions (Read Only)</title>
    <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55871#M62868</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I've seen that when I create any empty partition in kudu, it occupies around 65MiB in disk. I have some cases with a huge number of partitions, and this space is eatting up the disk, for partitons that are empty!! Is there a way to change this 'default' space occupied by partition? How?&lt;/P&gt;&lt;P&gt;Thank you very much!&lt;/P&gt;</description>
    <pubDate>Fri, 16 Sep 2022 11:45:19 GMT</pubDate>
    <dc:creator>albers2n</dc:creator>
    <dc:date>2022-09-16T11:45:19Z</dc:date>
    <item>
      <title>Space occupied by Kudu partition</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55871#M62868</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I've seen that when I create any empty partition in kudu, it occupies around 65MiB in disk. I have some cases with a huge number of partitions, and this space is eatting up the disk, for partitons that are empty!! Is there a way to change this 'default' space occupied by partition? How?&lt;/P&gt;&lt;P&gt;Thank you very much!&lt;/P&gt;</description>
      <pubDate>Fri, 16 Sep 2022 11:45:19 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55871#M62868</guid>
      <dc:creator>albers2n</dc:creator>
      <dc:date>2022-09-16T11:45:19Z</dc:date>
    </item>
    <item>
      <title>Re: Space occupied by Kudu partition</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55877#M62869</link>
      <description>&lt;P&gt;What version of Kudu are you using? How exactly did you measure the new partition's space consumption?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 14 Jun 2017 18:35:23 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55877#M62869</guid>
      <dc:creator>Adar</dc:creator>
      <dc:date>2017-06-14T18:35:23Z</dc:date>
    </item>
    <item>
      <title>Re: Space occupied by Kudu partition</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55924#M62870</link>
      <description>&lt;P&gt;First of all, thank you for your reply.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Kudu version:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;$ kudu -version
kudu 1.3.0-cdh5.11.0
revision 4dcf4a9d516865d249f4cb9b07f93c67e84614ae
build type RELEASE
built by jenkins at 12 Apr 2017 14:02:23 PST on impala-ec2-pkg-centos-7-0cb2.vpc.cloudera.com
build id 2017-04-12_13-25-54&lt;/PRE&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;To see the space consumption, I first see how much used&amp;nbsp;space I have in the FS:&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;/dev/mapper/vg_hadoop-lv_hadoop &amp;nbsp; 99G&amp;nbsp; 2.3G &amp;nbsp; 92G &amp;nbsp; 3% /opt/hadoop&lt;/PRE&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;Then&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN class="s1"&gt;I create a table using Impala with many partitions by range (50 for this example):&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;[bigdata04dev.cpd:21000] &amp;gt; CREATE TABLE vndr1.TEST_API_KUDU (
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; starttime BIGINT NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; rnc STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; nodeb STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; cell STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; vendor STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; ne_version STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; oss_avail_time STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; download_time STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; load_time STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; gp INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; call_attempts INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; data_traffic INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; drop_calls INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; error_bits INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; rab_fails INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; rrc_fails INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; voice_traffic INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; used_power INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; packet_duration INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PRIMARY KEY (starttime, rnc, nodeb, cell)
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; )
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; PARTITION BY RANGE (starttime)
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; (
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION VALUES &amp;lt; unix_timestamp('2016-05-22'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-22') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-23'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-23') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-24'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-24') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-25'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-25') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-26'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-26') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-27'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-27') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-28'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-28') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-29'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-29') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-30'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-30') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-31'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-05-31') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-01'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-01') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-02'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-02') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-03'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-03') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-04'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-04') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-05'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-05') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-06'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-06') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-07'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-07') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-08'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-08') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-09'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-09') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-10'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-10') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-11'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-11') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-12'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-12') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-13'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-13') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-14'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-14') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-15'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-15') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-16'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-16') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-17'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-17') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-18'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-18') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-19'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-19') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-20'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-20') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-21'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-21') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-22'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-22') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-23'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-23') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-24'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-24') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-25'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-25') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-26'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-26') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-27'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-27') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-28'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-28') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-29'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-29') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-30'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-06-30') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-01'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-01') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-02'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-02') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-03'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-03') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-04'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-04') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-05'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-05') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-06'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-06') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-07'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-07') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-08'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-08') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-09'),
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; &amp;nbsp; PARTITION unix_timestamp('2016-07-09') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-10')
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; )
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; STORED AS KUDU
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;gt; TBLPROPERTIES ('kudu.master_addresses'='192.168.10.35', 'kudu.table_name'='vndr1.TEST_API_KUDU');
Query: create TABLE vndr1.TEST_API_KUDU (
&amp;nbsp; starttime BIGINT NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; rnc STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; nodeb STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; cell STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; vendor STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; ne_version STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; oss_avail_time STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; download_time STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; load_time STRING NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; gp INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; call_attempts INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; data_traffic INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; drop_calls INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; error_bits INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; rab_fails INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; rrc_fails INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; voice_traffic INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; used_power INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; packet_duration INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
&amp;nbsp; PRIMARY KEY (starttime, rnc, nodeb, cell)
)
PARTITION BY RANGE (starttime)
(
&amp;nbsp; PARTITION VALUES &amp;lt; unix_timestamp('2016-05-22'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-22') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-23'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-23') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-24'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-24') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-25'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-25') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-26'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-26') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-27'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-27') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-28'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-28') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-29'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-29') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-30'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-30') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-05-31'),
&amp;nbsp; PARTITION unix_timestamp('2016-05-31') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-01'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-01') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-02'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-02') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-03'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-03') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-04'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-04') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-05'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-05') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-06'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-06') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-07'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-07') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-08'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-08') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-09'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-09') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-10'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-10') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-11'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-11') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-12'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-12') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-13'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-13') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-14'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-14') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-15'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-15') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-16'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-16') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-17'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-17') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-18'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-18') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-19'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-19') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-20'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-20') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-21'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-21') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-22'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-22') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-23'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-23') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-24'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-24') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-25'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-25') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-26'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-26') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-27'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-27') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-28'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-28') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-29'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-29') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-06-30'),
&amp;nbsp; PARTITION unix_timestamp('2016-06-30') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-01'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-01') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-02'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-02') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-03'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-03') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-04'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-04') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-05'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-05') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-06'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-06') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-07'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-07') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-08'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-08') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-09'),
&amp;nbsp; PARTITION unix_timestamp('2016-07-09') &amp;lt;= VALUES &amp;lt; unix_timestamp('2016-07-10')
)
STORED AS KUDU
TBLPROPERTIES ('kudu.master_addresses'='192.168.10.35', 'kudu.table_name'='vndr1.TEST_API_KUDU')

Fetched 0 row(s) in 0.80s
[bigdata04dev.cpd:21000] &amp;gt;&lt;/PRE&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;And then I see the used space again for this FS:&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;/dev/mapper/vg_hadoop-lv_hadoop   99G  5.4G   89G   6% /opt/hadoop&lt;/PRE&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;As you can see, it went from 2.3G to 5.4G with just 50 range partitions. That is around 63.5M each partition, and the table is empty.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;Thank you very much&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 15 Jun 2017 07:46:08 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55924#M62870</guid>
      <dc:creator>albers2n</dc:creator>
      <dc:date>2017-06-15T07:46:08Z</dc:date>
    </item>
    <item>
      <title>Re: Space occupied by Kudu partition</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55947#M62871</link>
      <description>&lt;P&gt;It would be interesting (and useful) to see what new files were created as part of the CREATE TABLE. I suspect the increase in consumption was due to new WAL segments. We create one per partition and in Kudu 1.3 I believe we preallocate it to 32M.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can you confirm this? Find Kudu's configured WAL directory and look at its contents before and after the CREATE TABLE.&lt;/P&gt;</description>
      <pubDate>Thu, 15 Jun 2017 16:43:28 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55947#M62871</guid>
      <dc:creator>Adar</dc:creator>
      <dc:date>2017-06-15T16:43:28Z</dc:date>
    </item>
    <item>
      <title>Re: Space occupied by Kudu partition</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55998#M62872</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The WAL directory is empty (there are no tables in Kudu right now):&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;bash-4.2$ ls -last
total 148
144 drwx------ 2 kudu kudu 143360 Jun 16 10:45 .
  4 drwx------ 6 kudu kudu   4096 May 16 11:05 ..
bash-4.2$ pwd
/opt/hadoop/kudu/tserver/wals&lt;/PRE&gt;&lt;P&gt;And when I create the table (using the same script as before) the content of the folder is this:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;bash-4.2$ pwd
/opt/hadoop/kudu/tserver/wals
bash-4.2$ ls -last
total 348
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 44738a508974486089d1af0b6fa07caa
144 drwx------ 52 kudu kudu 143360 Jun 16 10:48 .
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 5fb3fe9397e94ec0a042a152de68c49f
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 cd102f09427e4b61bd5f799a409371a0
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 5a68aac0f8e1452aad66bc23f1632997
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 3ff60b2b885b4db89adf8acba0c0f9bb
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 87f8a8fe81c9436d86439a827ed2abd9
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 531d52acc8fb467b9deb2608b60eb028
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 ade15170415f442dba2ac697eb882fbe
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 6a68fab92bb64f57a5dd9d521995cee9
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 5894dbdb7a7748de92e0d65102948f58
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 1cfa68a85b964d2ba41b64ac8b9523d3
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 2cef1717b4c646dfa93c7962438bd2e5
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 067a8f2b467b45af94225a099e18b4c8
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 c3f18cd8a1564e56a3cab5e7502ca5bb
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 03a8eb79664841509380078ddee7b335
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 dc57712b1d324567bcd9a7fd22e850b7
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 ec4fde3b8e2247c6ab2e0f54b0ec85fb
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 91d019cf106544a597e5f4e59e07a3db
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 352b0f986534489b9e6aab9e3bd9cbbd
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 ca21b5be58f8440c9be81da103befe2a
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 1bb6c183bdeb4acf849f772996c4e8bb
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 ec577d25518745dfa83c81301f0835f3
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 7108c9e5a6fa4a9abe2d1cff3488b34f
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 4fe6fddfe52842fe9dd73929924f48ef
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 e7c3f2130dfd49d3abc61949faaa22d1
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 60509a5c83ef4aeca27acb9803efad34
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 6b6d0c99a47847ee85ec47a25adbd562
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 8e16c9d9dc0d4b0ba7c766d0cd52bc0d
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 5bb9d62f9d6e41f3bb8561699d7e2ec7
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 ae880022adbf4e15b33d040f697dd41b
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 1505fda0c54b4d6985f972adee2653e5
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 731ab85af7d147d2bb073a303afbcd3a
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 5e0ed0b49cd24308a17579efd28a4e32
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 7f530a9b75de4d8e963edf94bf26d5ed
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 8da88e8125d94d79902657186ec64a1f
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 96bb669d137f43bca91c7092d58ab1d4
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 80c5525e11f84110bc2bfd753319d4ad
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 3eedf81e4d6249d88542d1b8c25c8835
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 9bab107a1fef479caea27fa1c3274ddc
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 e8894d2e4e434954b4ce3098e548ea7f
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 224f0d63c67b467487ad907e9190e186
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 d04cfd76d7f544fc95a8c2c48ae29180
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 812e787e1c5f4322bf2e8c889e948b11
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 852884d2a60e41a19280105fbd1f4214
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 b8bb2809b0ea41deaa2c6fd558741fdc
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 e24d509a924e47f78331bd35814d13bc
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 2de230d2953e4f74b862d8582ad49de3
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 69ad6736611f48b7bafe39bc356b4c19
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 f097ea00099145cc9674404d6c8d7de1
  4 drwx------  2 kudu kudu   4096 Jun 16 10:48 b3f038f88e58496990a8f4500ffcf2b1
  4 drwx------  6 kudu kudu   4096 May 16 11:05 ..&lt;/PRE&gt;&lt;P&gt;If I look inside one of the folders, I see this:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;bash-4.2$ cd f097ea00099145cc9674404d6c8d7de1/
bash-4.2$ ls -alst
total 65688
  144 drwx------ 52 kudu kudu   143360 Jun 16 10:48 ..
65536 -rw-------  1 kudu kudu 67108864 Jun 16 10:48 wal-000000001
    4 -rw-------  1 kudu kudu 24000000 Jun 16 10:48 index.000000000
    4 drwx------  2 kudu kudu     4096 Jun 16 10:48 .
bash-4.2$ &lt;/PRE&gt;&lt;P&gt;The WAL file is exactly 64MiB in size (seems like a default allocation), but the table is empty. Is there a way to configure this default allocation to be less?.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks a lot.&lt;/P&gt;</description>
      <pubDate>Fri, 16 Jun 2017 08:54:06 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/55998#M62872</guid>
      <dc:creator>albers2n</dc:creator>
      <dc:date>2017-06-16T08:54:06Z</dc:date>
    </item>
    <item>
      <title>Re: Space occupied by Kudu partition</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/56030#M62873</link>
      <description>&lt;P&gt;Yes, what you're observing is Kudu preallocating one 64 MB write-ahead log segment for each partition. The space will be filled once you start writing to the partition.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In Kudu 1.4 we dropped the segment size from 64 MB to 8 MB. If you'd like to make that change now, you can do so via the --log_segment_size_mb command line option. An alternative would be to disable preallocation via --log_async_preallocate_segments=false and/or --log_preallocate_segments=false, but that's not something we generally test so I would advise against it.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 16 Jun 2017 18:19:32 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/Space-occupied-by-Kudu-partition/m-p/56030#M62873</guid>
      <dc:creator>Adar</dc:creator>
      <dc:date>2017-06-16T18:19:32Z</dc:date>
    </item>
  </channel>
</rss>

