title: Loading data from HDFS to Kudu
body: <p>I'm trying to load data to a Kudu table but getting a strange result.</p>
  
  <p>In the Impala console I created an external table from the four HDFS files imported by Sqoop:</p>
  
  <pre><code>drop table if exists hdfs_datedim;
  create external table hdfs_datedim
  ( ... )
  row format
   delimited fields terminated by ','
  location '/user/me/DATEDIM';
  </code></pre>
  
  <p>A SELECT COUNT(*) tells me there lots of rows present. The data looks good when queried.</p>
  
  <p>I use a standard select into to copy the results</p>
  
  <pre><code>INSERT INTO impala_kudu.DATEDIM
  SELECT * FROM hdfs_datedim;
  </code></pre>
  
  <p>A SELECT COUNT(*) tells me impala_kudu.DATEDIM has four rows (the number of files in HDFS <strong>not</strong> the number of rows in the table.</p>
  
  <p>Any Ideas?</p>