title: How insert overwrite table in hive with diffrent where clauses?
body: <p>I want to read a .tsv file from Hbase into hive. The file has a columnfamily, which has 3 columns inside: news, social and all. The aim is to store these columns in an table in hbase which has the columns news, social and all.</p>
  
  <pre><code>CREATE EXTERNAL TABLE IF NOT EXISTS topwords_logs (key String,  
  columnfamily  String , wort String , col String, occurance int)ROW FORMAT 
  DELIMITED FIELDS TERMINATED BY '\t'STORED AS TEXTFILE LOCATION '/home
  /hfu/Testdaten';
  
  load data local inpath '/home/hfu/Testdaten/part-r-00000.tsv' into table topwords_logs;
  
  CREATE TABLE newtopwords (columnall int,  columnsocial int , columnnews int) PARTITIONED BY(wort STRING)  STORED AS SEQUENCEFILE;
  </code></pre>
  
  <p>Here i created a external table, which contain the data from hbase. Further on I created a table with the 3 columns.</p>
  
  <p>What i have tried so far is this: </p>
  
  <pre><code>insert overwrite table newtopwords partition(wort)
  select occurance ,'1', '1' , wort from topwords_log;
  </code></pre>
  
  <p>This Code works fine, but i have for each column an extra where clause. How can I insert data like this?  </p>
  
  <pre><code>insert overwrite table newtopwords partition(wort)
  values(columnall,(select occurance from topwords_logs where col =' all')),(columnnews,( select occurance from topwords_logs where col =' news')) ,(columnsocial,( select occurance from topwords_logs where col =' social')),(wort,(select wort from topwords_log));
  </code></pre>
  
  <p>This code isnt working ->NoViableAltException.</p>
  
  <p>On every example I just see Code, where they insert data without a Where clause. How can I insert Data with a Where clause?</p>