title: Can hive create an temorary table so I can get a small table for further queries?
body: <p>I have a table, the schema is as below:</p>
  
  <pre><code> struct TBL{
     1:optional string category;
     2:optional string endpoint; 
     3:optional string priority; 
     4:optional i64 timestap;
     5:optional string traceId;   
     6:optional string rpcId;     
     7:optional string businessId;
     8:optional string message;   
     9:optional int date;    
  }
  </code></pre>
  
  <p>I only care about <code>8:optional string message;</code> 
  <code>message</code> field is <code>log</code>.</p>
  
  <p>I have a list of urls some of which can be found in the <code>message</code> filed. I need find which urls can be found in the table. In the <code>message</code> filed, the url always comes with <code>"getRequestURL"</code> such as </p>
  
  <pre><code>10.128.226.31,[INFO  2019-03-13 10:00:18.770] [resin-port-9300-44] [aaaLiMKyYK9bNbetoyhLw_-301570423] com.example.cashpay.filter.StaticFilter.doFilter(StaticFilter.java:99) [getRequestURL=http://www.example.com/merchant/deduct/query/v3]
  </code></pre>
  
  <p>The table is very large. 
  I want to filter the table first, say: </p>
  
  <pre><code>select message from TBL where message like '%getRequestURL%' and date ='20190319'
  </code></pre>
  
  <p>and then I can use union query to found which urls are in the filtered table above.
  say:</p>
  
  <pre><code>    select 'com/res/doc/eula/help.html', count(1) from filtered_tbl where message like 'com/res/doc/eula/help.html'
      union
      select 'com/charge/bank/alipay_wap/', count(1) from filtered_tbl where message like 'com/charge/bank/'
      union
      select 'com/reductionActivity/queryRegisterStatus', count(1) from filtered_tbl where message like 'com/reductionActivity/queryRegisterStatus'
      union
      select 'com/charge/pushcmd', count(1) from filtered_tbl where message like 'com/charge/pushcmd'
  union......
  </code></pre>
  
  <p>Does hive support filter first? If it support, then what can I do?</p>