title: Hive External table not showing anything
body: <p>I am trying to learn Hive by following twitter data tutorial from the below link.
  <a href="https://github.com/cloudera/cdh-twitter-example/" rel="nofollow">https://github.com/cloudera/cdh-twitter-example/</a></p>
  
  <p>I have successfully installed and configured hadoop and hive and tested simple text file load into hive table. All working good so far.</p>
  
  <p>However, even thought files existed in hdfs, external table is showing nothing.</p>
  
  <p>I used the below code to create tables.</p>
  
  <pre><code>CREATE EXTERNAL TABLE (
  ... 
   Columns ....
  ...
  )
  PARTITIONED BY (datehour INT)
  ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
  LOCATION '/user/flume/tweets';
  </code></pre>
  
  <p>I think where the problem comes in is the folder structure in my hdfs ..
  it's currently follows year/month/day/hour/ like below.</p>
  
  <pre><code>/user
    -- /flume
        -- /tweets
            -- /2015         
                -- 04        
                  -- 01      
                   -- 13     
                   -- 14
                  -- 02
                   -- 15
                   -- 16
  </code></pre>
  
  <p>Is there a way to set the partition correctly for this folder structure when creating external table in Hive ?</p>
  
  <p>Thanks in advance for your help...</p>