ql/src/test/queries/clientpositive/llap_text.q

--! qt:dataset:alltypesorc
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
set hive.fetch.task.conversion=none;

SET hive.llap.io.enabled=false;
set hive.llap.cache.allow.synthetic.fileid=true;

-- SORT_QUERY_RESULTS

DROP TABLE text_llap;

CREATE TABLE text_llap(
    ctinyint TINYINT,
    csmallint SMALLINT,
    cint INT,
    cbigint BIGINT,
    cfloat FLOAT,
    cdouble DOUBLE,
    cstring1 STRING,
    cstring2 STRING,
    ctimestamp1 TIMESTAMP,
    ctimestamp2 TIMESTAMP,
    cboolean1 BOOLEAN,
    cboolean2 BOOLEAN)
row format serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
stored as inputformat "org.apache.hadoop.mapred.TextInputFormat" 
-- stored as inputformat "org.apache.hadoop.hive.llap.io.decode.LlapTextInputFormat" 
outputformat "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"
TBLPROPERTIES ("hive.serialization.decode.binary.as.base64"="false");

insert into table text_llap
select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 from alltypesorc 
where cboolean2 is not null or cstring1 is not null or ctinyint is not null;

create table text_llap2(
          t tinyint,
          si smallint,
          i int,
          b bigint,
          f float,
          d double,
          bo boolean,
          s string,
          ts timestamp, 
          `dec` decimal,  
          bin binary)
row format delimited fields terminated by '|'
stored as inputformat "org.apache.hadoop.mapred.TextInputFormat" 
-- stored as inputformat "org.apache.hadoop.hive.llap.io.decode.LlapTextInputFormat" 
outputformat "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"
TBLPROPERTIES ("hive.serialization.decode.binary.as.base64"="false");

load data local inpath '../../data/files/over10k.gz' into table text_llap2;



create table text_llap1 like text_llap; 
create table text_llap100 like text_llap; 
create table text_llap1000 like text_llap; 

insert into table text_llap1
select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 from alltypesorc 
where cboolean2 is not null or cstring1 is not null or ctinyint is not null limit 1;

insert into table text_llap100
select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 from alltypesorc 
where cboolean2 is not null or cstring1 is not null or ctinyint is not null limit 100;

insert into table text_llap1000
select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 from alltypesorc 
where cboolean2 is not null or cstring1 is not null or ctinyint is not null limit 1000;


SET hive.llap.io.enabled=true;
set hive.vectorized.use.row.serde.deserialize=false;
SET hive.vectorized.execution.enabled=true;
set hive.llap.io.encode.slice.row.count=90;

select t, s, ts from text_llap2 order by t, s, ts limit 100;
select * from text_llap2 order by t, s, ts limit 100;
select t, f, s from text_llap2 order by t, s, f limit 100;


select ctinyint, cstring1, cboolean2 from text_llap100 order by ctinyint, cstring1, cboolean2;
select * from text_llap100 order by cint, cstring1, cstring2;
select csmallint, cstring1, cboolean2 from text_llap100 order by csmallint, cstring1, cboolean2;

set hive.vectorized.use.row.serde.deserialize=true;
select t, s, ts from text_llap2 order by t, s, ts limit 100;
select csmallint, cstring1, cboolean2 from text_llap100 order by csmallint, cstring1, cboolean2;


DROP TABLE text_llap;