text: --
  -- Licensed to the Apache Software Foundation (ASF) under one
  -- or more contributor license agreements.  See the NOTICE file
  -- distributed with this work for additional information
  -- regarding copyright ownership.  The ASF licenses this file
  -- to you under the Apache License, Version 2.0 (the
  -- "License"); you may not use this file except in compliance
  -- with the License.  You may obtain a copy of the License at
  --
  --   http://www.apache.org/licenses/LICENSE-2.0
  --
  -- Unless required by applicable law or agreed to in writing,
  -- software distributed under the License is distributed on an
  -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  -- KIND, either express or implied.  See the License for the
  -- specific language governing permissions and limitations
  -- under the License.
  --
  
  cube select id,name from sample_dim
  cube select id,name from sample_dim where name != 'first'
  cube select id,name from sample_dim order by name
  cube select id,name from sample_dim order by name desc
  cube select id,name from sample_dim where name != 'first' order by name
  cube select id,name from sample_dim where name != 'first' order by name desc
  cube select id,name from sample_dim limit 2
  cube select id,name from sample_dim order by name limit 2
  cube select id,name from sample_dim order by name desc limit 2
  cube select id,name from sample_dim where name != 'first' limit 2
  cube select id,name from sample_dim where name != 'first' order by name limit 2
  cube select id,name from sample_dim where name != 'first' order by name desc limit 2
  cube select count(id) from sample_dim
  cube select count(id) from sample_dim group by name
  cube select count(distinct id) from sample_dim
  cube select sample_dim.name, sample_dim2.name from sample_dim
  cube select sample_dim.name, sample_dim2.name from sample_dim join sample_dim2
  cube select sample_dim.name, sample_dim2.name from sample_dim left outer join sample_dim2
  cube select sample_dim.name, sample_dim2.name from sample_dim right outer join sample_dim2
  cube select sample_dim.name, sample_dim2.name from sample_dim full outer join sample_dim2
  cube select count(id) from sample_dim where name != "first"
  cube select count(distinct id) from sample_dim where name != "first"
  cube select sample_dim.name, sample_dim2.name from sample_dim where sample_dim.name != 'first'
  cube select id,name from sample_db_dim
  cube select id,name from sample_db_dim where name != 'first'
  cube select id,name from sample_db_dim order by name
  cube select id,name from sample_db_dim order by name desc
  cube select id,name from sample_db_dim where name != 'first' order by name
  cube select id,name from sample_db_dim where name != 'first' order by name desc
  cube select id,name from sample_db_dim limit 2
  cube select id,name from sample_db_dim order by name limit 2
  cube select id,name from sample_db_dim order by name desc limit 2
  cube select id,name from sample_db_dim where name != 'first' limit 2
  cube select id,name from sample_db_dim where name != 'first' order by name limit 2
  cube select id,name from sample_db_dim where name != 'first' order by name desc limit 2
  cube select count(id) from sample_db_dim
  cube select count(id) from sample_db_dim group by name
  cube select count(distinct id) from sample_db_dim
  select * from (cube select sample_dim.name name1, sample_dim2.name name2 from sample_dim where sample_dim.name != 'first') a
  drop table temp1
  create table temp1 as cube select id,name from sample_dim
  select * from temp1
  insert overwrite local directory '/tmp/example-output' cube select id,name from sample_dim
  insert overwrite local directory '/tmp/example-output2' ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ('serialization.null.format'='-NA-','field.delim'=','  ) STORED AS TEXTFILE cube select id,name from sample_dim
  drop table temp2
  create table temp2(id int, name string)
  insert overwrite table temp2 cube select id,name from sample_dim
  select * from temp2
  drop table temp3
  create table temp3(id int, name string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ('serialization.null.format'='-NA-','field.delim'=','  ) STORED AS TEXTFILE
  insert overwrite table temp3 cube select id,name from sample_dim
  select * from temp3
  cube select name from city
  cube select name from city where population > 1000000
  cube select name, poi from city
  cube select distinct category from product
  cube select id, description from product where weight > 100
  cube select category, count(1) as `Number of products` from product
  cube select name, customer_city_name from customer
  cube select customer.name, customer_city.population from customer
  