title: Creating Hive table using HUE
body: <p>I installed a single node Cloudera to start learning about this technologies. Now, I'm trying to create a table on HUE from a CSV file.</p>
  
  <p>When I try to do it, the table is being created but without any data, just the columns structure and I'm getting the following error:</p>
  
  <blockquote>
    <p>Error while compiling statement: FAILED: SemanticException Line 1:17
    Invalid path ''/user/josholsan/ic_data/_glucosa.csv'': No files
    matching path
    hdfs://server_name:8020/user/josholsan/ic_data/_glucosa.csv</p>
  </blockquote>
  
  <p>The error says that there's no files matching this path, but when I try the following in the terminal, the file is right there:</p>
  
  <pre><code>hadoop fs -ls hdfs//server_name.8020/user/josholsan/ic_data/_glucosa.csv
  </code></pre>
  
  <p>The code HUE is executing to create the table is the following one:</p>
  
  <pre><code>CREATE TABLE `test`.`cpk`
  (
    `id` bigint ,
    `numsipcod` string ,
    `valor` bigint ,
    `fecharegistro` string )  ROW FORMAT   SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
    WITH SERDEPROPERTIES ("separatorChar" = "\t",
    "quoteChar"     = "\"",
    "escapeChar"    = "\\"
    )
    STORED AS TextFile TBLPROPERTIES("skip.header.line.count" = "1")
  ;
  
  LOAD DATA INPATH '/user/josholsan/ic_data/_glucosa.csv' INTO TABLE `test`.`glucosa`;
  </code></pre>
  
  <p>I also tried loading the file from local using LOAD DATA LOCAL INPATH.</p>
  
  <p>I don't actually know how to proceed. I've been checking the internet, but what I've found didnt helped me.
  There's something that call on my attention and is the permissions for this file when I write the command above this lines, and permissions are: 
  <strong>- rw-r--r--</strong></p>
  
  <p>Anyways, I disabled the permission checking in the HDFS settings.</p>
  
  <p>Anyone with HDFS/HUE/Cloudera knowledge knows which could be the problem in here?
  Thanks you so much in advance =)</p>