CREATE DATABASE IF NOT EXISTS functional_seq_record_bzip
Summary: Returned 1 rows
Success: True
Took: 0.0266020298004(s)
Data:
Database already exists.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypes
Summary: Returned 1 rows
Success: True
Took: 0.368494987488(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypes (
id int COMMENT 'Add a comment',
bool_col boolean,
tinyint_col tinyint,
smallint_col smallint,
int_col int,
bigint_col bigint,
float_col float,
double_col double,
date_string_col string,
string_col string,
timestamp_col timestamp
)
PARTITIONED BY (year int, month int)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypes_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.0724129676819(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.00764179229736(s)
Data:


ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=1)
Summary: Returned 1 rows
Success: True
Took: 0.313192129135(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=2)
Summary: Returned 1 rows
Success: True
Took: 0.032035112381(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=3)
Summary: Returned 1 rows
Success: True
Took: 0.0421929359436(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=4)
Summary: Returned 1 rows
Success: True
Took: 0.0335109233856(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=5)
Summary: Returned 1 rows
Success: True
Took: 0.0435769557953(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=6)
Summary: Returned 1 rows
Success: True
Took: 0.0551099777222(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=7)
Summary: Returned 1 rows
Success: True
Took: 0.0421957969666(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=8)
Summary: Returned 1 rows
Success: True
Took: 0.0418019294739(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=9)
Summary: Returned 1 rows
Success: True
Took: 0.056421995163(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=10)
Summary: Returned 1 rows
Success: True
Took: 0.0328879356384(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=11)
Summary: Returned 1 rows
Success: True
Took: 0.0394518375397(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2009, month=12)
Summary: Returned 1 rows
Success: True
Took: 0.0425159931183(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=1)
Summary: Returned 1 rows
Success: True
Took: 0.0411880016327(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=2)
Summary: Returned 1 rows
Success: True
Took: 0.0421710014343(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=3)
Summary: Returned 1 rows
Success: True
Took: 0.0624630451202(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=4)
Summary: Returned 1 rows
Success: True
Took: 0.0479879379272(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=5)
Summary: Returned 1 rows
Success: True
Took: 0.0540881156921(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=6)
Summary: Returned 1 rows
Success: True
Took: 0.0522830486298(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=7)
Summary: Returned 1 rows
Success: True
Took: 0.0472309589386(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=8)
Summary: Returned 1 rows
Success: True
Took: 0.107285022736(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=9)
Summary: Returned 1 rows
Success: True
Took: 0.0626769065857(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=10)
Summary: Returned 1 rows
Success: True
Took: 0.0626599788666(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=11)
Summary: Returned 1 rows
Success: True
Took: 0.0489039421082(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypes ADD IF NOT EXISTS PARTITION(year=2010, month=12)
Summary: Returned 1 rows
Success: True
Took: 0.0696451663971(s)
Data:
New partition has been added to the table.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypesnopart
Summary: Returned 1 rows
Success: True
Took: 0.438118934631(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypesnopart (
id int,
bool_col boolean,
tinyint_col tinyint,
smallint_col smallint,
int_col int,
bigint_col bigint,
float_col float,
double_col double,
date_string_col string,
string_col string,
timestamp_col timestamp
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS TEXTFILE
LOCATION '/test-warehouse/alltypesnopart_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.324739933014(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypessmall
Summary: Returned 1 rows
Success: True
Took: 0.420212030411(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypessmall (
id int,
bool_col boolean,
tinyint_col tinyint,
smallint_col smallint,
int_col int,
bigint_col bigint,
float_col float,
double_col double,
date_string_col string,
string_col string,
timestamp_col timestamp
)
PARTITIONED BY (year int, month int)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypessmall_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.232780218124(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.00830411911011(s)
Data:


ALTER TABLE alltypessmall ADD IF NOT EXISTS PARTITION(year=2009, month=1)
Summary: Returned 1 rows
Success: True
Took: 0.337329149246(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypessmall ADD IF NOT EXISTS PARTITION(year=2009, month=2)
Summary: Returned 1 rows
Success: True
Took: 0.0238800048828(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypessmall ADD IF NOT EXISTS PARTITION(year=2009, month=3)
Summary: Returned 1 rows
Success: True
Took: 0.0373990535736(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypessmall ADD IF NOT EXISTS PARTITION(year=2009, month=4)
Summary: Returned 1 rows
Success: True
Took: 0.0285720825195(s)
Data:
New partition has been added to the table.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypestiny
Summary: Returned 1 rows
Success: True
Took: 0.492781162262(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypestiny (
id int,
bool_col boolean,
tinyint_col tinyint,
smallint_col smallint,
int_col int,
bigint_col bigint,
float_col float,
double_col double,
date_string_col string,
string_col string,
timestamp_col timestamp
)
PARTITIONED BY (year int, month int)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypestiny_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.152402162552(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.00338196754456(s)
Data:


ALTER TABLE alltypestiny ADD IF NOT EXISTS PARTITION(year=2009, month=1)
Summary: Returned 1 rows
Success: True
Took: 0.180457830429(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypestiny ADD IF NOT EXISTS PARTITION(year=2009, month=2)
Summary: Returned 1 rows
Success: True
Took: 0.0547428131104(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypestiny ADD IF NOT EXISTS PARTITION(year=2009, month=3)
Summary: Returned 1 rows
Success: True
Took: 0.0468120574951(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypestiny ADD IF NOT EXISTS PARTITION(year=2009, month=4)
Summary: Returned 1 rows
Success: True
Took: 0.0634911060333(s)
Data:
New partition has been added to the table.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypeserror
Summary: Returned 1 rows
Success: True
Took: 0.224439144135(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypeserror (
  id int,
  bool_col boolean,
  tinyint_col tinyint,
  smallint_col smallint,
  int_col int,
  bigint_col bigint,
  float_col float,
  double_col double,
  date_string_col string,
  string_col string,
  timestamp_col timestamp)
partitioned by (year int, month int)
row format delimited fields terminated by ','  escaped by '\\'
stored as SEQUENCEFILE
LOCATION '/test-warehouse/alltypeserror_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.510209798813(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.00326013565063(s)
Data:


ALTER TABLE alltypeserror ADD IF NOT EXISTS PARTITION (year=2009, month=1)
Summary: Returned 1 rows
Success: True
Took: 0.167783021927(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypeserror ADD IF NOT EXISTS PARTITION (year=2009, month=2)
Summary: Returned 1 rows
Success: True
Took: 0.0253608226776(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypeserror ADD IF NOT EXISTS PARTITION (year=2009, month=3)
Summary: Returned 1 rows
Success: True
Took: 0.0251588821411(s)
Data:
New partition has been added to the table.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypeserror_tmp (
  id STRING,
  bool_col STRING,
  tinyint_col STRING,
  smallint_col STRING,
  int_col STRING,
  bigint_col STRING,
  float_col STRING,
  double_col STRING,
  date_string_col STRING,
  string_col STRING,
  timestamp_col STRING)
PARTITIONED BY (year INT, month INT)
ROW FORMAT DELIMITED
  FIELDS TERMINATED BY ','
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypeserror_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.280600070953(s)
Data:
Table has been created.

ALTER TABLE alltypeserror_tmp ADD IF NOT EXISTS PARTITION (year=2009, month=1)
Summary: Returned 1 rows
Success: True
Took: 0.159633874893(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypeserror_tmp ADD IF NOT EXISTS PARTITION (year=2009, month=2)
Summary: Returned 1 rows
Success: True
Took: 0.0375399589539(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypeserror_tmp ADD IF NOT EXISTS PARTITION (year=2009, month=3)
Summary: Returned 1 rows
Success: True
Took: 0.153763771057(s)
Data:
New partition has been added to the table.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypeserrornonulls
Summary: Returned 1 rows
Success: True
Took: 0.23857998848(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS  functional_seq_record_bzip.alltypeserrornonulls (
  id int,
  bool_col boolean,
  tinyint_col tinyint,
  smallint_col smallint,
  int_col int,
  bigint_col bigint,
  float_col float,
  double_col double,
  date_string_col string,
  string_col string,
  timestamp_col timestamp)
partitioned by (year int, month int)
row format delimited fields terminated by ','  escaped by '\\'
stored as SEQUENCEFILE
LOCATION '/test-warehouse/alltypeserrornonulls_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.256357908249(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.00347208976746(s)
Data:


ALTER TABLE alltypeserrornonulls ADD IF NOT EXISTS PARTITION (year=2009, month=1)
Summary: Returned 1 rows
Success: True
Took: 0.11872792244(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypeserrornonulls ADD IF NOT EXISTS PARTITION (year=2009, month=2)
Summary: Returned 1 rows
Success: True
Took: 0.0149228572845(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypeserrornonulls ADD IF NOT EXISTS PARTITION (year=2009, month=3)
Summary: Returned 1 rows
Success: True
Took: 0.0188319683075(s)
Data:
New partition has been added to the table.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypeserrornonulls_tmp (
  id STRING,
  bool_col STRING,
  tinyint_col STRING,
  smallint_col STRING,
  int_col STRING,
  bigint_col STRING,
  float_col STRING,
  double_col STRING,
  date_string_col STRING,
  string_col STRING,
  timestamp_col STRING)
PARTITIONED BY (year INT, month INT)
ROW FORMAT DELIMITED
  FIELDS TERMINATED BY ','
  ESCAPED BY '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypeserrornonulls_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.215743780136(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.00582385063171(s)
Data:


ALTER TABLE alltypeserrornonulls_tmp ADD IF NOT EXISTS PARTITION (year=2009, month=1)
Summary: Returned 1 rows
Success: True
Took: 0.166477203369(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypeserrornonulls_tmp ADD IF NOT EXISTS PARTITION (year=2009, month=2)
Summary: Returned 1 rows
Success: True
Took: 0.0271151065826(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypeserrornonulls_tmp ADD IF NOT EXISTS PARTITION (year=2009, month=3)
Summary: Returned 1 rows
Success: True
Took: 0.0423321723938(s)
Data:
New partition has been added to the table.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypesagg
Summary: Returned 1 rows
Success: True
Took: 0.522510051727(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypesagg (
id int,
bool_col boolean,
tinyint_col tinyint,
smallint_col smallint,
int_col int,
bigint_col bigint,
float_col float,
double_col double,
date_string_col string,
string_col string,
timestamp_col timestamp
)
PARTITIONED BY (year int, month int, day int)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypesagg_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.0347769260406(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.00322484970093(s)
Data:


ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=1)
Summary: Returned 1 rows
Success: True
Took: 0.138414144516(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=2)
Summary: Returned 1 rows
Success: True
Took: 0.039400100708(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=3)
Summary: Returned 1 rows
Success: True
Took: 0.0424559116364(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=4)
Summary: Returned 1 rows
Success: True
Took: 0.0336310863495(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=5)
Summary: Returned 1 rows
Success: True
Took: 0.0627679824829(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=6)
Summary: Returned 1 rows
Success: True
Took: 0.0354988574982(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=7)
Summary: Returned 1 rows
Success: True
Took: 0.055547952652(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=8)
Summary: Returned 1 rows
Success: True
Took: 0.146157026291(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=9)
Summary: Returned 1 rows
Success: True
Took: 0.117834806442(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=10)
Summary: Returned 1 rows
Success: True
Took: 0.0681788921356(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesagg ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=NULL)
Summary: Returned 1 rows
Success: True
Took: 0.0561690330505(s)
Data:
New partition has been added to the table.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypesaggnonulls
Summary: Returned 1 rows
Success: True
Took: 0.763507843018(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypesaggnonulls (
id int,
bool_col boolean,
tinyint_col tinyint,
smallint_col smallint,
int_col int,
bigint_col bigint,
float_col float,
double_col double,
date_string_col string,
string_col string,
timestamp_col timestamp
)
PARTITIONED BY (year int, month int, day int)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypesaggnonulls_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.211908817291(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.00432300567627(s)
Data:


ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=1)
Summary: Returned 1 rows
Success: True
Took: 0.235156059265(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=2)
Summary: Returned 1 rows
Success: True
Took: 0.0321838855743(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=3)
Summary: Returned 1 rows
Success: True
Took: 0.0313580036163(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=4)
Summary: Returned 1 rows
Success: True
Took: 0.0377240180969(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=5)
Summary: Returned 1 rows
Success: True
Took: 0.0220468044281(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=6)
Summary: Returned 1 rows
Success: True
Took: 0.0499248504639(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=7)
Summary: Returned 1 rows
Success: True
Took: 0.0791230201721(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=8)
Summary: Returned 1 rows
Success: True
Took: 0.0905740261078(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=9)
Summary: Returned 1 rows
Success: True
Took: 0.0801479816437(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggnonulls ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=10)
Summary: Returned 1 rows
Success: True
Took: 0.229046106339(s)
Data:
New partition has been added to the table.

DROP TABLE IF EXISTS functional_seq_record_bzip.testtbl
Summary: Returned 1 rows
Success: True
Took: 0.400650978088(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.testtbl (
id bigint,
name string,
zip int
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS TEXTFILE
LOCATION '/test-warehouse/testtbl_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.628845930099(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.dimtbl
Summary: Returned 1 rows
Success: True
Took: 0.373776197433(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.dimtbl (
id bigint,
name string,
zip int
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/dimtbl_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.494199037552(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.jointbl
Summary: Returned 1 rows
Success: True
Took: 0.387928962708(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.jointbl (
test_id bigint,
test_name string,
test_zip int,
alltypes_id int
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/jointbl_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.209018945694(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.liketbl
Summary: Returned 1 rows
Success: True
Took: 0.671396017075(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.liketbl (
str_col string,
match_like_col string,
no_match_like_col string,
match_regex_col string,
no_match_regex_col string
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/liketbl_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.347023010254(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.widerow
Summary: Returned 1 rows
Success: True
Took: 0.360902070999(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.widerow (
string_col string
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/widerow_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.596194982529(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.greptiny
Summary: Returned 1 rows
Success: True
Took: 0.231667995453(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.greptiny (
field string
)
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/greptiny_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.246734857559(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.rankingssmall
Summary: Returned 1 rows
Success: True
Took: 0.418614864349(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.rankingssmall (
pageRank int,
pageURL string,
avgDuration int
)
ROW FORMAT delimited fields terminated by '|'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/rankingssmall_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.131958961487(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.uservisitssmall
Summary: Returned 1 rows
Success: True
Took: 0.514521837234(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.uservisitssmall (
sourceIP string,
destURL string,
visitDate string,
adRevenue float,
userAgent string,
cCode string,
lCode string,
sKeyword string,
avgTimeOnSite int
)
ROW FORMAT delimited fields terminated by '|'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/uservisitssmall_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.0338790416718(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.emptytable
Summary: Returned 1 rows
Success: True
Took: 0.343795061111(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.emptytable (
field string
)
PARTITIONED BY (f2 int)
STORED AS TEXTFILE
LOCATION '/test-warehouse/emptytable_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.195608854294(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypesaggmultifiles
Summary: Returned 1 rows
Success: True
Took: 0.203471899033(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypesaggmultifiles (
id int,
bool_col boolean,
tinyint_col tinyint,
smallint_col smallint,
int_col int,
bigint_col bigint,
float_col float,
double_col double,
date_string_col string,
string_col string,
timestamp_col timestamp
)
PARTITIONED BY (year int, month int, day int)
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypesaggmultifiles_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.386394023895(s)
Data:
Table has been created.

USE functional_seq_record_bzip
Summary: 
Success: True
Took: 0.0035080909729(s)
Data:


ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=1)
Summary: Returned 1 rows
Success: True
Took: 0.16650390625(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=2)
Summary: Returned 1 rows
Success: True
Took: 0.0450141429901(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=3)
Summary: Returned 1 rows
Success: True
Took: 0.0230090618134(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=4)
Summary: Returned 1 rows
Success: True
Took: 0.0347089767456(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=5)
Summary: Returned 1 rows
Success: True
Took: 0.0209589004517(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=6)
Summary: Returned 1 rows
Success: True
Took: 0.0189509391785(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=7)
Summary: Returned 1 rows
Success: True
Took: 0.0187590122223(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=8)
Summary: Returned 1 rows
Success: True
Took: 0.0246911048889(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=9)
Summary: Returned 1 rows
Success: True
Took: 0.0190119743347(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=10)
Summary: Returned 1 rows
Success: True
Took: 0.0387060642242(s)
Data:
New partition has been added to the table.

ALTER TABLE alltypesaggmultifiles ADD IF NOT EXISTS PARTITION(year=2010, month=1, day=NULL)
Summary: Returned 1 rows
Success: True
Took: 0.0236928462982(s)
Data:
New partition has been added to the table.

DROP TABLE IF EXISTS functional_seq_record_bzip.alltypesaggmultifilesnopart
Summary: Returned 1 rows
Success: True
Took: 0.466650009155(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.alltypesaggmultifilesnopart (
id int,
bool_col boolean,
tinyint_col tinyint,
smallint_col smallint,
int_col int,
bigint_col bigint,
float_col float,
double_col double,
date_string_col string,
string_col string,
timestamp_col timestamp
)
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/alltypesaggmultifilesnopart_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.0909640789032(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.tinytable
Summary: Returned 1 rows
Success: True
Took: 0.282265901566(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.tinytable (
a string,
b string
)
ROW FORMAT delimited fields terminated by ','
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/tinytable_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.298642158508(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.tinyinttable
Summary: Returned 1 rows
Success: True
Took: 0.353796005249(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.tinyinttable (
int_col int
)
ROW FORMAT delimited fields terminated by ','
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/tinyinttable_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.0756130218506(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.nulltable
Summary: Returned 1 rows
Success: True
Took: 0.237412929535(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.nulltable (
a string,
b string,
c string,
d int,
e double,
f string,
g string
)
ROW FORMAT delimited fields terminated by ','
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/nulltable_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.29482293129(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.nullrows
Summary: Returned 1 rows
Success: True
Took: 0.337248086929(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.nullrows (
id string,
blank string,
null_str string,
null_int int,
null_double double,
group_str string,
some_nulls string,
bool_nulls boolean
)
ROW FORMAT delimited fields terminated by ','
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/nullrows_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.0224800109863(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.nullescapedtable
Summary: Returned 1 rows
Success: True
Took: 0.444207906723(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.nullescapedtable (
a string,
b string,
c string,
d int,
e double,
f string,
g string
)
ROW FORMAT delimited fields terminated by ',' escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/nullescapedtable_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.086189031601(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.TblWithRaggedColumns
Summary: Returned 1 rows
Success: True
Took: 0.173547029495(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.TblWithRaggedColumns (
str_col string,
int_col int
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/TblWithRaggedColumns_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.196024894714(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.zipcode_incomes
Summary: Returned 1 rows
Success: True
Took: 0.400398015976(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.zipcode_incomes (
id STRING,
zip STRING,
description1 STRING,
description2 STRING,
income int
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/zipcode_incomes_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 0.372458934784(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.parent_table
Summary: Returned 1 rows
Success: True
Took: 0.285794973373(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.parent_table (
id INT, year string, primary key(id, year) DISABLE NOVALIDATE RELY)
row format delimited fields terminated by ','
LOCATION '/test-warehouse/parent_table'
Summary: Returned 1 rows
Success: True
Took: 0.305382013321(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.parent_table_2
Summary: Returned 1 rows
Success: True
Took: 0.511268138885(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.parent_table_2 (
a INT, primary key(a) DISABLE NOVALIDATE RELY)
row format delimited fields terminated by ','
LOCATION '/test-warehouse/parent_table_2'
Summary: Returned 1 rows
Success: True
Took: 0.126410007477(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.child_table
Summary: Returned 1 rows
Success: True
Took: 0.469799041748(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.child_table (
seq int, id int, year string, a int, primary key(seq) DISABLE NOVALIDATE RELY, foreign key
(id, year) references functional_seq_record_bzip.parent_table(id, year) DISABLE NOVALIDATE
RELY, foreign key(a) references functional_seq_record_bzip.parent_table_2(a) DISABLE
NOVALIDATE RELY)
row format delimited fields terminated by ','
LOCATION '/test-warehouse/child_table'
Summary: Returned 1 rows
Success: True
Took: 0.878261089325(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.chars_tiny
Summary: Returned 1 rows
Success: True
Took: 0.749046087265(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.chars_tiny (
cs CHAR(5),
cl CHAR(140),
vc VARCHAR(32)
)
ROW FORMAT delimited fields terminated by ','
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/chars_tiny_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 1.29334712029(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.widetable_250_cols
Summary: Returned 1 rows
Success: True
Took: 0.951942205429(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.widetable_250_cols (
bool_col1 BOOLEAN,
tinyint_col1 TINYINT,
smallint_col1 SMALLINT,
int_col1 INT,
bigint_col1 BIGINT,
float_col1 FLOAT,
double_col1 DOUBLE,
string_col1 STRING,
bool_col2 BOOLEAN,
tinyint_col2 TINYINT,
smallint_col2 SMALLINT,
int_col2 INT,
bigint_col2 BIGINT,
float_col2 FLOAT,
double_col2 DOUBLE,
string_col2 STRING,
bool_col3 BOOLEAN,
tinyint_col3 TINYINT,
smallint_col3 SMALLINT,
int_col3 INT,
bigint_col3 BIGINT,
float_col3 FLOAT,
double_col3 DOUBLE,
string_col3 STRING,
bool_col4 BOOLEAN,
tinyint_col4 TINYINT,
smallint_col4 SMALLINT,
int_col4 INT,
bigint_col4 BIGINT,
float_col4 FLOAT,
double_col4 DOUBLE,
string_col4 STRING,
bool_col5 BOOLEAN,
tinyint_col5 TINYINT,
smallint_col5 SMALLINT,
int_col5 INT,
bigint_col5 BIGINT,
float_col5 FLOAT,
double_col5 DOUBLE,
string_col5 STRING,
bool_col6 BOOLEAN,
tinyint_col6 TINYINT,
smallint_col6 SMALLINT,
int_col6 INT,
bigint_col6 BIGINT,
float_col6 FLOAT,
double_col6 DOUBLE,
string_col6 STRING,
bool_col7 BOOLEAN,
tinyint_col7 TINYINT,
smallint_col7 SMALLINT,
int_col7 INT,
bigint_col7 BIGINT,
float_col7 FLOAT,
double_col7 DOUBLE,
string_col7 STRING,
bool_col8 BOOLEAN,
tinyint_col8 TINYINT,
smallint_col8 SMALLINT,
int_col8 INT,
bigint_col8 BIGINT,
float_col8 FLOAT,
double_col8 DOUBLE,
string_col8 STRING,
bool_col9 BOOLEAN,
tinyint_col9 TINYINT,
smallint_col9 SMALLINT,
int_col9 INT,
bigint_col9 BIGINT,
float_col9 FLOAT,
double_col9 DOUBLE,
string_col9 STRING,
bool_col10 BOOLEAN,
tinyint_col10 TINYINT,
smallint_col10 SMALLINT,
int_col10 INT,
bigint_col10 BIGINT,
float_col10 FLOAT,
double_col10 DOUBLE,
string_col10 STRING,
bool_col11 BOOLEAN,
tinyint_col11 TINYINT,
smallint_col11 SMALLINT,
int_col11 INT,
bigint_col11 BIGINT,
float_col11 FLOAT,
double_col11 DOUBLE,
string_col11 STRING,
bool_col12 BOOLEAN,
tinyint_col12 TINYINT,
smallint_col12 SMALLINT,
int_col12 INT,
bigint_col12 BIGINT,
float_col12 FLOAT,
double_col12 DOUBLE,
string_col12 STRING,
bool_col13 BOOLEAN,
tinyint_col13 TINYINT,
smallint_col13 SMALLINT,
int_col13 INT,
bigint_col13 BIGINT,
float_col13 FLOAT,
double_col13 DOUBLE,
string_col13 STRING,
bool_col14 BOOLEAN,
tinyint_col14 TINYINT,
smallint_col14 SMALLINT,
int_col14 INT,
bigint_col14 BIGINT,
float_col14 FLOAT,
double_col14 DOUBLE,
string_col14 STRING,
bool_col15 BOOLEAN,
tinyint_col15 TINYINT,
smallint_col15 SMALLINT,
int_col15 INT,
bigint_col15 BIGINT,
float_col15 FLOAT,
double_col15 DOUBLE,
string_col15 STRING,
bool_col16 BOOLEAN,
tinyint_col16 TINYINT,
smallint_col16 SMALLINT,
int_col16 INT,
bigint_col16 BIGINT,
float_col16 FLOAT,
double_col16 DOUBLE,
string_col16 STRING,
bool_col17 BOOLEAN,
tinyint_col17 TINYINT,
smallint_col17 SMALLINT,
int_col17 INT,
bigint_col17 BIGINT,
float_col17 FLOAT,
double_col17 DOUBLE,
string_col17 STRING,
bool_col18 BOOLEAN,
tinyint_col18 TINYINT,
smallint_col18 SMALLINT,
int_col18 INT,
bigint_col18 BIGINT,
float_col18 FLOAT,
double_col18 DOUBLE,
string_col18 STRING,
bool_col19 BOOLEAN,
tinyint_col19 TINYINT,
smallint_col19 SMALLINT,
int_col19 INT,
bigint_col19 BIGINT,
float_col19 FLOAT,
double_col19 DOUBLE,
string_col19 STRING,
bool_col20 BOOLEAN,
tinyint_col20 TINYINT,
smallint_col20 SMALLINT,
int_col20 INT,
bigint_col20 BIGINT,
float_col20 FLOAT,
double_col20 DOUBLE,
string_col20 STRING,
bool_col21 BOOLEAN,
tinyint_col21 TINYINT,
smallint_col21 SMALLINT,
int_col21 INT,
bigint_col21 BIGINT,
float_col21 FLOAT,
double_col21 DOUBLE,
string_col21 STRING,
bool_col22 BOOLEAN,
tinyint_col22 TINYINT,
smallint_col22 SMALLINT,
int_col22 INT,
bigint_col22 BIGINT,
float_col22 FLOAT,
double_col22 DOUBLE,
string_col22 STRING,
bool_col23 BOOLEAN,
tinyint_col23 TINYINT,
smallint_col23 SMALLINT,
int_col23 INT,
bigint_col23 BIGINT,
float_col23 FLOAT,
double_col23 DOUBLE,
string_col23 STRING,
bool_col24 BOOLEAN,
tinyint_col24 TINYINT,
smallint_col24 SMALLINT,
int_col24 INT,
bigint_col24 BIGINT,
float_col24 FLOAT,
double_col24 DOUBLE,
string_col24 STRING,
bool_col25 BOOLEAN,
tinyint_col25 TINYINT,
smallint_col25 SMALLINT,
int_col25 INT,
bigint_col25 BIGINT,
float_col25 FLOAT,
double_col25 DOUBLE,
string_col25 STRING,
bool_col26 BOOLEAN,
tinyint_col26 TINYINT,
smallint_col26 SMALLINT,
int_col26 INT,
bigint_col26 BIGINT,
float_col26 FLOAT,
double_col26 DOUBLE,
string_col26 STRING,
bool_col27 BOOLEAN,
tinyint_col27 TINYINT,
smallint_col27 SMALLINT,
int_col27 INT,
bigint_col27 BIGINT,
float_col27 FLOAT,
double_col27 DOUBLE,
string_col27 STRING,
bool_col28 BOOLEAN,
tinyint_col28 TINYINT,
smallint_col28 SMALLINT,
int_col28 INT,
bigint_col28 BIGINT,
float_col28 FLOAT,
double_col28 DOUBLE,
string_col28 STRING,
bool_col29 BOOLEAN,
tinyint_col29 TINYINT,
smallint_col29 SMALLINT,
int_col29 INT,
bigint_col29 BIGINT,
float_col29 FLOAT,
double_col29 DOUBLE,
string_col29 STRING,
bool_col30 BOOLEAN,
tinyint_col30 TINYINT,
smallint_col30 SMALLINT,
int_col30 INT,
bigint_col30 BIGINT,
float_col30 FLOAT,
double_col30 DOUBLE,
string_col30 STRING,
bool_col31 BOOLEAN,
tinyint_col31 TINYINT,
smallint_col31 SMALLINT,
int_col31 INT,
bigint_col31 BIGINT,
float_col31 FLOAT,
double_col31 DOUBLE,
string_col31 STRING,
bool_col32 BOOLEAN,
tinyint_col32 TINYINT
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/widetable_250_cols_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 2.12701702118(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.widetable_500_cols
Summary: Returned 1 rows
Success: True
Took: 0.947648048401(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.widetable_500_cols (
bool_col1 BOOLEAN,
tinyint_col1 TINYINT,
smallint_col1 SMALLINT,
int_col1 INT,
bigint_col1 BIGINT,
float_col1 FLOAT,
double_col1 DOUBLE,
string_col1 STRING,
bool_col2 BOOLEAN,
tinyint_col2 TINYINT,
smallint_col2 SMALLINT,
int_col2 INT,
bigint_col2 BIGINT,
float_col2 FLOAT,
double_col2 DOUBLE,
string_col2 STRING,
bool_col3 BOOLEAN,
tinyint_col3 TINYINT,
smallint_col3 SMALLINT,
int_col3 INT,
bigint_col3 BIGINT,
float_col3 FLOAT,
double_col3 DOUBLE,
string_col3 STRING,
bool_col4 BOOLEAN,
tinyint_col4 TINYINT,
smallint_col4 SMALLINT,
int_col4 INT,
bigint_col4 BIGINT,
float_col4 FLOAT,
double_col4 DOUBLE,
string_col4 STRING,
bool_col5 BOOLEAN,
tinyint_col5 TINYINT,
smallint_col5 SMALLINT,
int_col5 INT,
bigint_col5 BIGINT,
float_col5 FLOAT,
double_col5 DOUBLE,
string_col5 STRING,
bool_col6 BOOLEAN,
tinyint_col6 TINYINT,
smallint_col6 SMALLINT,
int_col6 INT,
bigint_col6 BIGINT,
float_col6 FLOAT,
double_col6 DOUBLE,
string_col6 STRING,
bool_col7 BOOLEAN,
tinyint_col7 TINYINT,
smallint_col7 SMALLINT,
int_col7 INT,
bigint_col7 BIGINT,
float_col7 FLOAT,
double_col7 DOUBLE,
string_col7 STRING,
bool_col8 BOOLEAN,
tinyint_col8 TINYINT,
smallint_col8 SMALLINT,
int_col8 INT,
bigint_col8 BIGINT,
float_col8 FLOAT,
double_col8 DOUBLE,
string_col8 STRING,
bool_col9 BOOLEAN,
tinyint_col9 TINYINT,
smallint_col9 SMALLINT,
int_col9 INT,
bigint_col9 BIGINT,
float_col9 FLOAT,
double_col9 DOUBLE,
string_col9 STRING,
bool_col10 BOOLEAN,
tinyint_col10 TINYINT,
smallint_col10 SMALLINT,
int_col10 INT,
bigint_col10 BIGINT,
float_col10 FLOAT,
double_col10 DOUBLE,
string_col10 STRING,
bool_col11 BOOLEAN,
tinyint_col11 TINYINT,
smallint_col11 SMALLINT,
int_col11 INT,
bigint_col11 BIGINT,
float_col11 FLOAT,
double_col11 DOUBLE,
string_col11 STRING,
bool_col12 BOOLEAN,
tinyint_col12 TINYINT,
smallint_col12 SMALLINT,
int_col12 INT,
bigint_col12 BIGINT,
float_col12 FLOAT,
double_col12 DOUBLE,
string_col12 STRING,
bool_col13 BOOLEAN,
tinyint_col13 TINYINT,
smallint_col13 SMALLINT,
int_col13 INT,
bigint_col13 BIGINT,
float_col13 FLOAT,
double_col13 DOUBLE,
string_col13 STRING,
bool_col14 BOOLEAN,
tinyint_col14 TINYINT,
smallint_col14 SMALLINT,
int_col14 INT,
bigint_col14 BIGINT,
float_col14 FLOAT,
double_col14 DOUBLE,
string_col14 STRING,
bool_col15 BOOLEAN,
tinyint_col15 TINYINT,
smallint_col15 SMALLINT,
int_col15 INT,
bigint_col15 BIGINT,
float_col15 FLOAT,
double_col15 DOUBLE,
string_col15 STRING,
bool_col16 BOOLEAN,
tinyint_col16 TINYINT,
smallint_col16 SMALLINT,
int_col16 INT,
bigint_col16 BIGINT,
float_col16 FLOAT,
double_col16 DOUBLE,
string_col16 STRING,
bool_col17 BOOLEAN,
tinyint_col17 TINYINT,
smallint_col17 SMALLINT,
int_col17 INT,
bigint_col17 BIGINT,
float_col17 FLOAT,
double_col17 DOUBLE,
string_col17 STRING,
bool_col18 BOOLEAN,
tinyint_col18 TINYINT,
smallint_col18 SMALLINT,
int_col18 INT,
bigint_col18 BIGINT,
float_col18 FLOAT,
double_col18 DOUBLE,
string_col18 STRING,
bool_col19 BOOLEAN,
tinyint_col19 TINYINT,
smallint_col19 SMALLINT,
int_col19 INT,
bigint_col19 BIGINT,
float_col19 FLOAT,
double_col19 DOUBLE,
string_col19 STRING,
bool_col20 BOOLEAN,
tinyint_col20 TINYINT,
smallint_col20 SMALLINT,
int_col20 INT,
bigint_col20 BIGINT,
float_col20 FLOAT,
double_col20 DOUBLE,
string_col20 STRING,
bool_col21 BOOLEAN,
tinyint_col21 TINYINT,
smallint_col21 SMALLINT,
int_col21 INT,
bigint_col21 BIGINT,
float_col21 FLOAT,
double_col21 DOUBLE,
string_col21 STRING,
bool_col22 BOOLEAN,
tinyint_col22 TINYINT,
smallint_col22 SMALLINT,
int_col22 INT,
bigint_col22 BIGINT,
float_col22 FLOAT,
double_col22 DOUBLE,
string_col22 STRING,
bool_col23 BOOLEAN,
tinyint_col23 TINYINT,
smallint_col23 SMALLINT,
int_col23 INT,
bigint_col23 BIGINT,
float_col23 FLOAT,
double_col23 DOUBLE,
string_col23 STRING,
bool_col24 BOOLEAN,
tinyint_col24 TINYINT,
smallint_col24 SMALLINT,
int_col24 INT,
bigint_col24 BIGINT,
float_col24 FLOAT,
double_col24 DOUBLE,
string_col24 STRING,
bool_col25 BOOLEAN,
tinyint_col25 TINYINT,
smallint_col25 SMALLINT,
int_col25 INT,
bigint_col25 BIGINT,
float_col25 FLOAT,
double_col25 DOUBLE,
string_col25 STRING,
bool_col26 BOOLEAN,
tinyint_col26 TINYINT,
smallint_col26 SMALLINT,
int_col26 INT,
bigint_col26 BIGINT,
float_col26 FLOAT,
double_col26 DOUBLE,
string_col26 STRING,
bool_col27 BOOLEAN,
tinyint_col27 TINYINT,
smallint_col27 SMALLINT,
int_col27 INT,
bigint_col27 BIGINT,
float_col27 FLOAT,
double_col27 DOUBLE,
string_col27 STRING,
bool_col28 BOOLEAN,
tinyint_col28 TINYINT,
smallint_col28 SMALLINT,
int_col28 INT,
bigint_col28 BIGINT,
float_col28 FLOAT,
double_col28 DOUBLE,
string_col28 STRING,
bool_col29 BOOLEAN,
tinyint_col29 TINYINT,
smallint_col29 SMALLINT,
int_col29 INT,
bigint_col29 BIGINT,
float_col29 FLOAT,
double_col29 DOUBLE,
string_col29 STRING,
bool_col30 BOOLEAN,
tinyint_col30 TINYINT,
smallint_col30 SMALLINT,
int_col30 INT,
bigint_col30 BIGINT,
float_col30 FLOAT,
double_col30 DOUBLE,
string_col30 STRING,
bool_col31 BOOLEAN,
tinyint_col31 TINYINT,
smallint_col31 SMALLINT,
int_col31 INT,
bigint_col31 BIGINT,
float_col31 FLOAT,
double_col31 DOUBLE,
string_col31 STRING,
bool_col32 BOOLEAN,
tinyint_col32 TINYINT,
smallint_col32 SMALLINT,
int_col32 INT,
bigint_col32 BIGINT,
float_col32 FLOAT,
double_col32 DOUBLE,
string_col32 STRING,
bool_col33 BOOLEAN,
tinyint_col33 TINYINT,
smallint_col33 SMALLINT,
int_col33 INT,
bigint_col33 BIGINT,
float_col33 FLOAT,
double_col33 DOUBLE,
string_col33 STRING,
bool_col34 BOOLEAN,
tinyint_col34 TINYINT,
smallint_col34 SMALLINT,
int_col34 INT,
bigint_col34 BIGINT,
float_col34 FLOAT,
double_col34 DOUBLE,
string_col34 STRING,
bool_col35 BOOLEAN,
tinyint_col35 TINYINT,
smallint_col35 SMALLINT,
int_col35 INT,
bigint_col35 BIGINT,
float_col35 FLOAT,
double_col35 DOUBLE,
string_col35 STRING,
bool_col36 BOOLEAN,
tinyint_col36 TINYINT,
smallint_col36 SMALLINT,
int_col36 INT,
bigint_col36 BIGINT,
float_col36 FLOAT,
double_col36 DOUBLE,
string_col36 STRING,
bool_col37 BOOLEAN,
tinyint_col37 TINYINT,
smallint_col37 SMALLINT,
int_col37 INT,
bigint_col37 BIGINT,
float_col37 FLOAT,
double_col37 DOUBLE,
string_col37 STRING,
bool_col38 BOOLEAN,
tinyint_col38 TINYINT,
smallint_col38 SMALLINT,
int_col38 INT,
bigint_col38 BIGINT,
float_col38 FLOAT,
double_col38 DOUBLE,
string_col38 STRING,
bool_col39 BOOLEAN,
tinyint_col39 TINYINT,
smallint_col39 SMALLINT,
int_col39 INT,
bigint_col39 BIGINT,
float_col39 FLOAT,
double_col39 DOUBLE,
string_col39 STRING,
bool_col40 BOOLEAN,
tinyint_col40 TINYINT,
smallint_col40 SMALLINT,
int_col40 INT,
bigint_col40 BIGINT,
float_col40 FLOAT,
double_col40 DOUBLE,
string_col40 STRING,
bool_col41 BOOLEAN,
tinyint_col41 TINYINT,
smallint_col41 SMALLINT,
int_col41 INT,
bigint_col41 BIGINT,
float_col41 FLOAT,
double_col41 DOUBLE,
string_col41 STRING,
bool_col42 BOOLEAN,
tinyint_col42 TINYINT,
smallint_col42 SMALLINT,
int_col42 INT,
bigint_col42 BIGINT,
float_col42 FLOAT,
double_col42 DOUBLE,
string_col42 STRING,
bool_col43 BOOLEAN,
tinyint_col43 TINYINT,
smallint_col43 SMALLINT,
int_col43 INT,
bigint_col43 BIGINT,
float_col43 FLOAT,
double_col43 DOUBLE,
string_col43 STRING,
bool_col44 BOOLEAN,
tinyint_col44 TINYINT,
smallint_col44 SMALLINT,
int_col44 INT,
bigint_col44 BIGINT,
float_col44 FLOAT,
double_col44 DOUBLE,
string_col44 STRING,
bool_col45 BOOLEAN,
tinyint_col45 TINYINT,
smallint_col45 SMALLINT,
int_col45 INT,
bigint_col45 BIGINT,
float_col45 FLOAT,
double_col45 DOUBLE,
string_col45 STRING,
bool_col46 BOOLEAN,
tinyint_col46 TINYINT,
smallint_col46 SMALLINT,
int_col46 INT,
bigint_col46 BIGINT,
float_col46 FLOAT,
double_col46 DOUBLE,
string_col46 STRING,
bool_col47 BOOLEAN,
tinyint_col47 TINYINT,
smallint_col47 SMALLINT,
int_col47 INT,
bigint_col47 BIGINT,
float_col47 FLOAT,
double_col47 DOUBLE,
string_col47 STRING,
bool_col48 BOOLEAN,
tinyint_col48 TINYINT,
smallint_col48 SMALLINT,
int_col48 INT,
bigint_col48 BIGINT,
float_col48 FLOAT,
double_col48 DOUBLE,
string_col48 STRING,
bool_col49 BOOLEAN,
tinyint_col49 TINYINT,
smallint_col49 SMALLINT,
int_col49 INT,
bigint_col49 BIGINT,
float_col49 FLOAT,
double_col49 DOUBLE,
string_col49 STRING,
bool_col50 BOOLEAN,
tinyint_col50 TINYINT,
smallint_col50 SMALLINT,
int_col50 INT,
bigint_col50 BIGINT,
float_col50 FLOAT,
double_col50 DOUBLE,
string_col50 STRING,
bool_col51 BOOLEAN,
tinyint_col51 TINYINT,
smallint_col51 SMALLINT,
int_col51 INT,
bigint_col51 BIGINT,
float_col51 FLOAT,
double_col51 DOUBLE,
string_col51 STRING,
bool_col52 BOOLEAN,
tinyint_col52 TINYINT,
smallint_col52 SMALLINT,
int_col52 INT,
bigint_col52 BIGINT,
float_col52 FLOAT,
double_col52 DOUBLE,
string_col52 STRING,
bool_col53 BOOLEAN,
tinyint_col53 TINYINT,
smallint_col53 SMALLINT,
int_col53 INT,
bigint_col53 BIGINT,
float_col53 FLOAT,
double_col53 DOUBLE,
string_col53 STRING,
bool_col54 BOOLEAN,
tinyint_col54 TINYINT,
smallint_col54 SMALLINT,
int_col54 INT,
bigint_col54 BIGINT,
float_col54 FLOAT,
double_col54 DOUBLE,
string_col54 STRING,
bool_col55 BOOLEAN,
tinyint_col55 TINYINT,
smallint_col55 SMALLINT,
int_col55 INT,
bigint_col55 BIGINT,
float_col55 FLOAT,
double_col55 DOUBLE,
string_col55 STRING,
bool_col56 BOOLEAN,
tinyint_col56 TINYINT,
smallint_col56 SMALLINT,
int_col56 INT,
bigint_col56 BIGINT,
float_col56 FLOAT,
double_col56 DOUBLE,
string_col56 STRING,
bool_col57 BOOLEAN,
tinyint_col57 TINYINT,
smallint_col57 SMALLINT,
int_col57 INT,
bigint_col57 BIGINT,
float_col57 FLOAT,
double_col57 DOUBLE,
string_col57 STRING,
bool_col58 BOOLEAN,
tinyint_col58 TINYINT,
smallint_col58 SMALLINT,
int_col58 INT,
bigint_col58 BIGINT,
float_col58 FLOAT,
double_col58 DOUBLE,
string_col58 STRING,
bool_col59 BOOLEAN,
tinyint_col59 TINYINT,
smallint_col59 SMALLINT,
int_col59 INT,
bigint_col59 BIGINT,
float_col59 FLOAT,
double_col59 DOUBLE,
string_col59 STRING,
bool_col60 BOOLEAN,
tinyint_col60 TINYINT,
smallint_col60 SMALLINT,
int_col60 INT,
bigint_col60 BIGINT,
float_col60 FLOAT,
double_col60 DOUBLE,
string_col60 STRING,
bool_col61 BOOLEAN,
tinyint_col61 TINYINT,
smallint_col61 SMALLINT,
int_col61 INT,
bigint_col61 BIGINT,
float_col61 FLOAT,
double_col61 DOUBLE,
string_col61 STRING,
bool_col62 BOOLEAN,
tinyint_col62 TINYINT,
smallint_col62 SMALLINT,
int_col62 INT,
bigint_col62 BIGINT,
float_col62 FLOAT,
double_col62 DOUBLE,
string_col62 STRING,
bool_col63 BOOLEAN,
tinyint_col63 TINYINT,
smallint_col63 SMALLINT,
int_col63 INT
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/widetable_500_cols_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 1.61667919159(s)
Data:
Table has been created.

DROP TABLE IF EXISTS functional_seq_record_bzip.widetable_1000_cols
Summary: Returned 1 rows
Success: True
Took: 1.79227900505(s)
Data:
Table has been dropped.

CREATE EXTERNAL TABLE IF NOT EXISTS functional_seq_record_bzip.widetable_1000_cols (
bool_col1 BOOLEAN,
tinyint_col1 TINYINT,
smallint_col1 SMALLINT,
int_col1 INT,
bigint_col1 BIGINT,
float_col1 FLOAT,
double_col1 DOUBLE,
string_col1 STRING,
bool_col2 BOOLEAN,
tinyint_col2 TINYINT,
smallint_col2 SMALLINT,
int_col2 INT,
bigint_col2 BIGINT,
float_col2 FLOAT,
double_col2 DOUBLE,
string_col2 STRING,
bool_col3 BOOLEAN,
tinyint_col3 TINYINT,
smallint_col3 SMALLINT,
int_col3 INT,
bigint_col3 BIGINT,
float_col3 FLOAT,
double_col3 DOUBLE,
string_col3 STRING,
bool_col4 BOOLEAN,
tinyint_col4 TINYINT,
smallint_col4 SMALLINT,
int_col4 INT,
bigint_col4 BIGINT,
float_col4 FLOAT,
double_col4 DOUBLE,
string_col4 STRING,
bool_col5 BOOLEAN,
tinyint_col5 TINYINT,
smallint_col5 SMALLINT,
int_col5 INT,
bigint_col5 BIGINT,
float_col5 FLOAT,
double_col5 DOUBLE,
string_col5 STRING,
bool_col6 BOOLEAN,
tinyint_col6 TINYINT,
smallint_col6 SMALLINT,
int_col6 INT,
bigint_col6 BIGINT,
float_col6 FLOAT,
double_col6 DOUBLE,
string_col6 STRING,
bool_col7 BOOLEAN,
tinyint_col7 TINYINT,
smallint_col7 SMALLINT,
int_col7 INT,
bigint_col7 BIGINT,
float_col7 FLOAT,
double_col7 DOUBLE,
string_col7 STRING,
bool_col8 BOOLEAN,
tinyint_col8 TINYINT,
smallint_col8 SMALLINT,
int_col8 INT,
bigint_col8 BIGINT,
float_col8 FLOAT,
double_col8 DOUBLE,
string_col8 STRING,
bool_col9 BOOLEAN,
tinyint_col9 TINYINT,
smallint_col9 SMALLINT,
int_col9 INT,
bigint_col9 BIGINT,
float_col9 FLOAT,
double_col9 DOUBLE,
string_col9 STRING,
bool_col10 BOOLEAN,
tinyint_col10 TINYINT,
smallint_col10 SMALLINT,
int_col10 INT,
bigint_col10 BIGINT,
float_col10 FLOAT,
double_col10 DOUBLE,
string_col10 STRING,
bool_col11 BOOLEAN,
tinyint_col11 TINYINT,
smallint_col11 SMALLINT,
int_col11 INT,
bigint_col11 BIGINT,
float_col11 FLOAT,
double_col11 DOUBLE,
string_col11 STRING,
bool_col12 BOOLEAN,
tinyint_col12 TINYINT,
smallint_col12 SMALLINT,
int_col12 INT,
bigint_col12 BIGINT,
float_col12 FLOAT,
double_col12 DOUBLE,
string_col12 STRING,
bool_col13 BOOLEAN,
tinyint_col13 TINYINT,
smallint_col13 SMALLINT,
int_col13 INT,
bigint_col13 BIGINT,
float_col13 FLOAT,
double_col13 DOUBLE,
string_col13 STRING,
bool_col14 BOOLEAN,
tinyint_col14 TINYINT,
smallint_col14 SMALLINT,
int_col14 INT,
bigint_col14 BIGINT,
float_col14 FLOAT,
double_col14 DOUBLE,
string_col14 STRING,
bool_col15 BOOLEAN,
tinyint_col15 TINYINT,
smallint_col15 SMALLINT,
int_col15 INT,
bigint_col15 BIGINT,
float_col15 FLOAT,
double_col15 DOUBLE,
string_col15 STRING,
bool_col16 BOOLEAN,
tinyint_col16 TINYINT,
smallint_col16 SMALLINT,
int_col16 INT,
bigint_col16 BIGINT,
float_col16 FLOAT,
double_col16 DOUBLE,
string_col16 STRING,
bool_col17 BOOLEAN,
tinyint_col17 TINYINT,
smallint_col17 SMALLINT,
int_col17 INT,
bigint_col17 BIGINT,
float_col17 FLOAT,
double_col17 DOUBLE,
string_col17 STRING,
bool_col18 BOOLEAN,
tinyint_col18 TINYINT,
smallint_col18 SMALLINT,
int_col18 INT,
bigint_col18 BIGINT,
float_col18 FLOAT,
double_col18 DOUBLE,
string_col18 STRING,
bool_col19 BOOLEAN,
tinyint_col19 TINYINT,
smallint_col19 SMALLINT,
int_col19 INT,
bigint_col19 BIGINT,
float_col19 FLOAT,
double_col19 DOUBLE,
string_col19 STRING,
bool_col20 BOOLEAN,
tinyint_col20 TINYINT,
smallint_col20 SMALLINT,
int_col20 INT,
bigint_col20 BIGINT,
float_col20 FLOAT,
double_col20 DOUBLE,
string_col20 STRING,
bool_col21 BOOLEAN,
tinyint_col21 TINYINT,
smallint_col21 SMALLINT,
int_col21 INT,
bigint_col21 BIGINT,
float_col21 FLOAT,
double_col21 DOUBLE,
string_col21 STRING,
bool_col22 BOOLEAN,
tinyint_col22 TINYINT,
smallint_col22 SMALLINT,
int_col22 INT,
bigint_col22 BIGINT,
float_col22 FLOAT,
double_col22 DOUBLE,
string_col22 STRING,
bool_col23 BOOLEAN,
tinyint_col23 TINYINT,
smallint_col23 SMALLINT,
int_col23 INT,
bigint_col23 BIGINT,
float_col23 FLOAT,
double_col23 DOUBLE,
string_col23 STRING,
bool_col24 BOOLEAN,
tinyint_col24 TINYINT,
smallint_col24 SMALLINT,
int_col24 INT,
bigint_col24 BIGINT,
float_col24 FLOAT,
double_col24 DOUBLE,
string_col24 STRING,
bool_col25 BOOLEAN,
tinyint_col25 TINYINT,
smallint_col25 SMALLINT,
int_col25 INT,
bigint_col25 BIGINT,
float_col25 FLOAT,
double_col25 DOUBLE,
string_col25 STRING,
bool_col26 BOOLEAN,
tinyint_col26 TINYINT,
smallint_col26 SMALLINT,
int_col26 INT,
bigint_col26 BIGINT,
float_col26 FLOAT,
double_col26 DOUBLE,
string_col26 STRING,
bool_col27 BOOLEAN,
tinyint_col27 TINYINT,
smallint_col27 SMALLINT,
int_col27 INT,
bigint_col27 BIGINT,
float_col27 FLOAT,
double_col27 DOUBLE,
string_col27 STRING,
bool_col28 BOOLEAN,
tinyint_col28 TINYINT,
smallint_col28 SMALLINT,
int_col28 INT,
bigint_col28 BIGINT,
float_col28 FLOAT,
double_col28 DOUBLE,
string_col28 STRING,
bool_col29 BOOLEAN,
tinyint_col29 TINYINT,
smallint_col29 SMALLINT,
int_col29 INT,
bigint_col29 BIGINT,
float_col29 FLOAT,
double_col29 DOUBLE,
string_col29 STRING,
bool_col30 BOOLEAN,
tinyint_col30 TINYINT,
smallint_col30 SMALLINT,
int_col30 INT,
bigint_col30 BIGINT,
float_col30 FLOAT,
double_col30 DOUBLE,
string_col30 STRING,
bool_col31 BOOLEAN,
tinyint_col31 TINYINT,
smallint_col31 SMALLINT,
int_col31 INT,
bigint_col31 BIGINT,
float_col31 FLOAT,
double_col31 DOUBLE,
string_col31 STRING,
bool_col32 BOOLEAN,
tinyint_col32 TINYINT,
smallint_col32 SMALLINT,
int_col32 INT,
bigint_col32 BIGINT,
float_col32 FLOAT,
double_col32 DOUBLE,
string_col32 STRING,
bool_col33 BOOLEAN,
tinyint_col33 TINYINT,
smallint_col33 SMALLINT,
int_col33 INT,
bigint_col33 BIGINT,
float_col33 FLOAT,
double_col33 DOUBLE,
string_col33 STRING,
bool_col34 BOOLEAN,
tinyint_col34 TINYINT,
smallint_col34 SMALLINT,
int_col34 INT,
bigint_col34 BIGINT,
float_col34 FLOAT,
double_col34 DOUBLE,
string_col34 STRING,
bool_col35 BOOLEAN,
tinyint_col35 TINYINT,
smallint_col35 SMALLINT,
int_col35 INT,
bigint_col35 BIGINT,
float_col35 FLOAT,
double_col35 DOUBLE,
string_col35 STRING,
bool_col36 BOOLEAN,
tinyint_col36 TINYINT,
smallint_col36 SMALLINT,
int_col36 INT,
bigint_col36 BIGINT,
float_col36 FLOAT,
double_col36 DOUBLE,
string_col36 STRING,
bool_col37 BOOLEAN,
tinyint_col37 TINYINT,
smallint_col37 SMALLINT,
int_col37 INT,
bigint_col37 BIGINT,
float_col37 FLOAT,
double_col37 DOUBLE,
string_col37 STRING,
bool_col38 BOOLEAN,
tinyint_col38 TINYINT,
smallint_col38 SMALLINT,
int_col38 INT,
bigint_col38 BIGINT,
float_col38 FLOAT,
double_col38 DOUBLE,
string_col38 STRING,
bool_col39 BOOLEAN,
tinyint_col39 TINYINT,
smallint_col39 SMALLINT,
int_col39 INT,
bigint_col39 BIGINT,
float_col39 FLOAT,
double_col39 DOUBLE,
string_col39 STRING,
bool_col40 BOOLEAN,
tinyint_col40 TINYINT,
smallint_col40 SMALLINT,
int_col40 INT,
bigint_col40 BIGINT,
float_col40 FLOAT,
double_col40 DOUBLE,
string_col40 STRING,
bool_col41 BOOLEAN,
tinyint_col41 TINYINT,
smallint_col41 SMALLINT,
int_col41 INT,
bigint_col41 BIGINT,
float_col41 FLOAT,
double_col41 DOUBLE,
string_col41 STRING,
bool_col42 BOOLEAN,
tinyint_col42 TINYINT,
smallint_col42 SMALLINT,
int_col42 INT,
bigint_col42 BIGINT,
float_col42 FLOAT,
double_col42 DOUBLE,
string_col42 STRING,
bool_col43 BOOLEAN,
tinyint_col43 TINYINT,
smallint_col43 SMALLINT,
int_col43 INT,
bigint_col43 BIGINT,
float_col43 FLOAT,
double_col43 DOUBLE,
string_col43 STRING,
bool_col44 BOOLEAN,
tinyint_col44 TINYINT,
smallint_col44 SMALLINT,
int_col44 INT,
bigint_col44 BIGINT,
float_col44 FLOAT,
double_col44 DOUBLE,
string_col44 STRING,
bool_col45 BOOLEAN,
tinyint_col45 TINYINT,
smallint_col45 SMALLINT,
int_col45 INT,
bigint_col45 BIGINT,
float_col45 FLOAT,
double_col45 DOUBLE,
string_col45 STRING,
bool_col46 BOOLEAN,
tinyint_col46 TINYINT,
smallint_col46 SMALLINT,
int_col46 INT,
bigint_col46 BIGINT,
float_col46 FLOAT,
double_col46 DOUBLE,
string_col46 STRING,
bool_col47 BOOLEAN,
tinyint_col47 TINYINT,
smallint_col47 SMALLINT,
int_col47 INT,
bigint_col47 BIGINT,
float_col47 FLOAT,
double_col47 DOUBLE,
string_col47 STRING,
bool_col48 BOOLEAN,
tinyint_col48 TINYINT,
smallint_col48 SMALLINT,
int_col48 INT,
bigint_col48 BIGINT,
float_col48 FLOAT,
double_col48 DOUBLE,
string_col48 STRING,
bool_col49 BOOLEAN,
tinyint_col49 TINYINT,
smallint_col49 SMALLINT,
int_col49 INT,
bigint_col49 BIGINT,
float_col49 FLOAT,
double_col49 DOUBLE,
string_col49 STRING,
bool_col50 BOOLEAN,
tinyint_col50 TINYINT,
smallint_col50 SMALLINT,
int_col50 INT,
bigint_col50 BIGINT,
float_col50 FLOAT,
double_col50 DOUBLE,
string_col50 STRING,
bool_col51 BOOLEAN,
tinyint_col51 TINYINT,
smallint_col51 SMALLINT,
int_col51 INT,
bigint_col51 BIGINT,
float_col51 FLOAT,
double_col51 DOUBLE,
string_col51 STRING,
bool_col52 BOOLEAN,
tinyint_col52 TINYINT,
smallint_col52 SMALLINT,
int_col52 INT,
bigint_col52 BIGINT,
float_col52 FLOAT,
double_col52 DOUBLE,
string_col52 STRING,
bool_col53 BOOLEAN,
tinyint_col53 TINYINT,
smallint_col53 SMALLINT,
int_col53 INT,
bigint_col53 BIGINT,
float_col53 FLOAT,
double_col53 DOUBLE,
string_col53 STRING,
bool_col54 BOOLEAN,
tinyint_col54 TINYINT,
smallint_col54 SMALLINT,
int_col54 INT,
bigint_col54 BIGINT,
float_col54 FLOAT,
double_col54 DOUBLE,
string_col54 STRING,
bool_col55 BOOLEAN,
tinyint_col55 TINYINT,
smallint_col55 SMALLINT,
int_col55 INT,
bigint_col55 BIGINT,
float_col55 FLOAT,
double_col55 DOUBLE,
string_col55 STRING,
bool_col56 BOOLEAN,
tinyint_col56 TINYINT,
smallint_col56 SMALLINT,
int_col56 INT,
bigint_col56 BIGINT,
float_col56 FLOAT,
double_col56 DOUBLE,
string_col56 STRING,
bool_col57 BOOLEAN,
tinyint_col57 TINYINT,
smallint_col57 SMALLINT,
int_col57 INT,
bigint_col57 BIGINT,
float_col57 FLOAT,
double_col57 DOUBLE,
string_col57 STRING,
bool_col58 BOOLEAN,
tinyint_col58 TINYINT,
smallint_col58 SMALLINT,
int_col58 INT,
bigint_col58 BIGINT,
float_col58 FLOAT,
double_col58 DOUBLE,
string_col58 STRING,
bool_col59 BOOLEAN,
tinyint_col59 TINYINT,
smallint_col59 SMALLINT,
int_col59 INT,
bigint_col59 BIGINT,
float_col59 FLOAT,
double_col59 DOUBLE,
string_col59 STRING,
bool_col60 BOOLEAN,
tinyint_col60 TINYINT,
smallint_col60 SMALLINT,
int_col60 INT,
bigint_col60 BIGINT,
float_col60 FLOAT,
double_col60 DOUBLE,
string_col60 STRING,
bool_col61 BOOLEAN,
tinyint_col61 TINYINT,
smallint_col61 SMALLINT,
int_col61 INT,
bigint_col61 BIGINT,
float_col61 FLOAT,
double_col61 DOUBLE,
string_col61 STRING,
bool_col62 BOOLEAN,
tinyint_col62 TINYINT,
smallint_col62 SMALLINT,
int_col62 INT,
bigint_col62 BIGINT,
float_col62 FLOAT,
double_col62 DOUBLE,
string_col62 STRING,
bool_col63 BOOLEAN,
tinyint_col63 TINYINT,
smallint_col63 SMALLINT,
int_col63 INT,
bigint_col63 BIGINT,
float_col63 FLOAT,
double_col63 DOUBLE,
string_col63 STRING,
bool_col64 BOOLEAN,
tinyint_col64 TINYINT,
smallint_col64 SMALLINT,
int_col64 INT,
bigint_col64 BIGINT,
float_col64 FLOAT,
double_col64 DOUBLE,
string_col64 STRING,
bool_col65 BOOLEAN,
tinyint_col65 TINYINT,
smallint_col65 SMALLINT,
int_col65 INT,
bigint_col65 BIGINT,
float_col65 FLOAT,
double_col65 DOUBLE,
string_col65 STRING,
bool_col66 BOOLEAN,
tinyint_col66 TINYINT,
smallint_col66 SMALLINT,
int_col66 INT,
bigint_col66 BIGINT,
float_col66 FLOAT,
double_col66 DOUBLE,
string_col66 STRING,
bool_col67 BOOLEAN,
tinyint_col67 TINYINT,
smallint_col67 SMALLINT,
int_col67 INT,
bigint_col67 BIGINT,
float_col67 FLOAT,
double_col67 DOUBLE,
string_col67 STRING,
bool_col68 BOOLEAN,
tinyint_col68 TINYINT,
smallint_col68 SMALLINT,
int_col68 INT,
bigint_col68 BIGINT,
float_col68 FLOAT,
double_col68 DOUBLE,
string_col68 STRING,
bool_col69 BOOLEAN,
tinyint_col69 TINYINT,
smallint_col69 SMALLINT,
int_col69 INT,
bigint_col69 BIGINT,
float_col69 FLOAT,
double_col69 DOUBLE,
string_col69 STRING,
bool_col70 BOOLEAN,
tinyint_col70 TINYINT,
smallint_col70 SMALLINT,
int_col70 INT,
bigint_col70 BIGINT,
float_col70 FLOAT,
double_col70 DOUBLE,
string_col70 STRING,
bool_col71 BOOLEAN,
tinyint_col71 TINYINT,
smallint_col71 SMALLINT,
int_col71 INT,
bigint_col71 BIGINT,
float_col71 FLOAT,
double_col71 DOUBLE,
string_col71 STRING,
bool_col72 BOOLEAN,
tinyint_col72 TINYINT,
smallint_col72 SMALLINT,
int_col72 INT,
bigint_col72 BIGINT,
float_col72 FLOAT,
double_col72 DOUBLE,
string_col72 STRING,
bool_col73 BOOLEAN,
tinyint_col73 TINYINT,
smallint_col73 SMALLINT,
int_col73 INT,
bigint_col73 BIGINT,
float_col73 FLOAT,
double_col73 DOUBLE,
string_col73 STRING,
bool_col74 BOOLEAN,
tinyint_col74 TINYINT,
smallint_col74 SMALLINT,
int_col74 INT,
bigint_col74 BIGINT,
float_col74 FLOAT,
double_col74 DOUBLE,
string_col74 STRING,
bool_col75 BOOLEAN,
tinyint_col75 TINYINT,
smallint_col75 SMALLINT,
int_col75 INT,
bigint_col75 BIGINT,
float_col75 FLOAT,
double_col75 DOUBLE,
string_col75 STRING,
bool_col76 BOOLEAN,
tinyint_col76 TINYINT,
smallint_col76 SMALLINT,
int_col76 INT,
bigint_col76 BIGINT,
float_col76 FLOAT,
double_col76 DOUBLE,
string_col76 STRING,
bool_col77 BOOLEAN,
tinyint_col77 TINYINT,
smallint_col77 SMALLINT,
int_col77 INT,
bigint_col77 BIGINT,
float_col77 FLOAT,
double_col77 DOUBLE,
string_col77 STRING,
bool_col78 BOOLEAN,
tinyint_col78 TINYINT,
smallint_col78 SMALLINT,
int_col78 INT,
bigint_col78 BIGINT,
float_col78 FLOAT,
double_col78 DOUBLE,
string_col78 STRING,
bool_col79 BOOLEAN,
tinyint_col79 TINYINT,
smallint_col79 SMALLINT,
int_col79 INT,
bigint_col79 BIGINT,
float_col79 FLOAT,
double_col79 DOUBLE,
string_col79 STRING,
bool_col80 BOOLEAN,
tinyint_col80 TINYINT,
smallint_col80 SMALLINT,
int_col80 INT,
bigint_col80 BIGINT,
float_col80 FLOAT,
double_col80 DOUBLE,
string_col80 STRING,
bool_col81 BOOLEAN,
tinyint_col81 TINYINT,
smallint_col81 SMALLINT,
int_col81 INT,
bigint_col81 BIGINT,
float_col81 FLOAT,
double_col81 DOUBLE,
string_col81 STRING,
bool_col82 BOOLEAN,
tinyint_col82 TINYINT,
smallint_col82 SMALLINT,
int_col82 INT,
bigint_col82 BIGINT,
float_col82 FLOAT,
double_col82 DOUBLE,
string_col82 STRING,
bool_col83 BOOLEAN,
tinyint_col83 TINYINT,
smallint_col83 SMALLINT,
int_col83 INT,
bigint_col83 BIGINT,
float_col83 FLOAT,
double_col83 DOUBLE,
string_col83 STRING,
bool_col84 BOOLEAN,
tinyint_col84 TINYINT,
smallint_col84 SMALLINT,
int_col84 INT,
bigint_col84 BIGINT,
float_col84 FLOAT,
double_col84 DOUBLE,
string_col84 STRING,
bool_col85 BOOLEAN,
tinyint_col85 TINYINT,
smallint_col85 SMALLINT,
int_col85 INT,
bigint_col85 BIGINT,
float_col85 FLOAT,
double_col85 DOUBLE,
string_col85 STRING,
bool_col86 BOOLEAN,
tinyint_col86 TINYINT,
smallint_col86 SMALLINT,
int_col86 INT,
bigint_col86 BIGINT,
float_col86 FLOAT,
double_col86 DOUBLE,
string_col86 STRING,
bool_col87 BOOLEAN,
tinyint_col87 TINYINT,
smallint_col87 SMALLINT,
int_col87 INT,
bigint_col87 BIGINT,
float_col87 FLOAT,
double_col87 DOUBLE,
string_col87 STRING,
bool_col88 BOOLEAN,
tinyint_col88 TINYINT,
smallint_col88 SMALLINT,
int_col88 INT,
bigint_col88 BIGINT,
float_col88 FLOAT,
double_col88 DOUBLE,
string_col88 STRING,
bool_col89 BOOLEAN,
tinyint_col89 TINYINT,
smallint_col89 SMALLINT,
int_col89 INT,
bigint_col89 BIGINT,
float_col89 FLOAT,
double_col89 DOUBLE,
string_col89 STRING,
bool_col90 BOOLEAN,
tinyint_col90 TINYINT,
smallint_col90 SMALLINT,
int_col90 INT,
bigint_col90 BIGINT,
float_col90 FLOAT,
double_col90 DOUBLE,
string_col90 STRING,
bool_col91 BOOLEAN,
tinyint_col91 TINYINT,
smallint_col91 SMALLINT,
int_col91 INT,
bigint_col91 BIGINT,
float_col91 FLOAT,
double_col91 DOUBLE,
string_col91 STRING,
bool_col92 BOOLEAN,
tinyint_col92 TINYINT,
smallint_col92 SMALLINT,
int_col92 INT,
bigint_col92 BIGINT,
float_col92 FLOAT,
double_col92 DOUBLE,
string_col92 STRING,
bool_col93 BOOLEAN,
tinyint_col93 TINYINT,
smallint_col93 SMALLINT,
int_col93 INT,
bigint_col93 BIGINT,
float_col93 FLOAT,
double_col93 DOUBLE,
string_col93 STRING,
bool_col94 BOOLEAN,
tinyint_col94 TINYINT,
smallint_col94 SMALLINT,
int_col94 INT,
bigint_col94 BIGINT,
float_col94 FLOAT,
double_col94 DOUBLE,
string_col94 STRING,
bool_col95 BOOLEAN,
tinyint_col95 TINYINT,
smallint_col95 SMALLINT,
int_col95 INT,
bigint_col95 BIGINT,
float_col95 FLOAT,
double_col95 DOUBLE,
string_col95 STRING,
bool_col96 BOOLEAN,
tinyint_col96 TINYINT,
smallint_col96 SMALLINT,
int_col96 INT,
bigint_col96 BIGINT,
float_col96 FLOAT,
double_col96 DOUBLE,
string_col96 STRING,
bool_col97 BOOLEAN,
tinyint_col97 TINYINT,
smallint_col97 SMALLINT,
int_col97 INT,
bigint_col97 BIGINT,
float_col97 FLOAT,
double_col97 DOUBLE,
string_col97 STRING,
bool_col98 BOOLEAN,
tinyint_col98 TINYINT,
smallint_col98 SMALLINT,
int_col98 INT,
bigint_col98 BIGINT,
float_col98 FLOAT,
double_col98 DOUBLE,
string_col98 STRING,
bool_col99 BOOLEAN,
tinyint_col99 TINYINT,
smallint_col99 SMALLINT,
int_col99 INT,
bigint_col99 BIGINT,
float_col99 FLOAT,
double_col99 DOUBLE,
string_col99 STRING,
bool_col100 BOOLEAN,
tinyint_col100 TINYINT,
smallint_col100 SMALLINT,
int_col100 INT,
bigint_col100 BIGINT,
float_col100 FLOAT,
double_col100 DOUBLE,
string_col100 STRING,
bool_col101 BOOLEAN,
tinyint_col101 TINYINT,
smallint_col101 SMALLINT,
int_col101 INT,
bigint_col101 BIGINT,
float_col101 FLOAT,
double_col101 DOUBLE,
string_col101 STRING,
bool_col102 BOOLEAN,
tinyint_col102 TINYINT,
smallint_col102 SMALLINT,
int_col102 INT,
bigint_col102 BIGINT,
float_col102 FLOAT,
double_col102 DOUBLE,
string_col102 STRING,
bool_col103 BOOLEAN,
tinyint_col103 TINYINT,
smallint_col103 SMALLINT,
int_col103 INT,
bigint_col103 BIGINT,
float_col103 FLOAT,
double_col103 DOUBLE,
string_col103 STRING,
bool_col104 BOOLEAN,
tinyint_col104 TINYINT,
smallint_col104 SMALLINT,
int_col104 INT,
bigint_col104 BIGINT,
float_col104 FLOAT,
double_col104 DOUBLE,
string_col104 STRING,
bool_col105 BOOLEAN,
tinyint_col105 TINYINT,
smallint_col105 SMALLINT,
int_col105 INT,
bigint_col105 BIGINT,
float_col105 FLOAT,
double_col105 DOUBLE,
string_col105 STRING,
bool_col106 BOOLEAN,
tinyint_col106 TINYINT,
smallint_col106 SMALLINT,
int_col106 INT,
bigint_col106 BIGINT,
float_col106 FLOAT,
double_col106 DOUBLE,
string_col106 STRING,
bool_col107 BOOLEAN,
tinyint_col107 TINYINT,
smallint_col107 SMALLINT,
int_col107 INT,
bigint_col107 BIGINT,
float_col107 FLOAT,
double_col107 DOUBLE,
string_col107 STRING,
bool_col108 BOOLEAN,
tinyint_col108 TINYINT,
smallint_col108 SMALLINT,
int_col108 INT,
bigint_col108 BIGINT,
float_col108 FLOAT,
double_col108 DOUBLE,
string_col108 STRING,
bool_col109 BOOLEAN,
tinyint_col109 TINYINT,
smallint_col109 SMALLINT,
int_col109 INT,
bigint_col109 BIGINT,
float_col109 FLOAT,
double_col109 DOUBLE,
string_col109 STRING,
bool_col110 BOOLEAN,
tinyint_col110 TINYINT,
smallint_col110 SMALLINT,
int_col110 INT,
bigint_col110 BIGINT,
float_col110 FLOAT,
double_col110 DOUBLE,
string_col110 STRING,
bool_col111 BOOLEAN,
tinyint_col111 TINYINT,
smallint_col111 SMALLINT,
int_col111 INT,
bigint_col111 BIGINT,
float_col111 FLOAT,
double_col111 DOUBLE,
string_col111 STRING,
bool_col112 BOOLEAN,
tinyint_col112 TINYINT,
smallint_col112 SMALLINT,
int_col112 INT,
bigint_col112 BIGINT,
float_col112 FLOAT,
double_col112 DOUBLE,
string_col112 STRING,
bool_col113 BOOLEAN,
tinyint_col113 TINYINT,
smallint_col113 SMALLINT,
int_col113 INT,
bigint_col113 BIGINT,
float_col113 FLOAT,
double_col113 DOUBLE,
string_col113 STRING,
bool_col114 BOOLEAN,
tinyint_col114 TINYINT,
smallint_col114 SMALLINT,
int_col114 INT,
bigint_col114 BIGINT,
float_col114 FLOAT,
double_col114 DOUBLE,
string_col114 STRING,
bool_col115 BOOLEAN,
tinyint_col115 TINYINT,
smallint_col115 SMALLINT,
int_col115 INT,
bigint_col115 BIGINT,
float_col115 FLOAT,
double_col115 DOUBLE,
string_col115 STRING,
bool_col116 BOOLEAN,
tinyint_col116 TINYINT,
smallint_col116 SMALLINT,
int_col116 INT,
bigint_col116 BIGINT,
float_col116 FLOAT,
double_col116 DOUBLE,
string_col116 STRING,
bool_col117 BOOLEAN,
tinyint_col117 TINYINT,
smallint_col117 SMALLINT,
int_col117 INT,
bigint_col117 BIGINT,
float_col117 FLOAT,
double_col117 DOUBLE,
string_col117 STRING,
bool_col118 BOOLEAN,
tinyint_col118 TINYINT,
smallint_col118 SMALLINT,
int_col118 INT,
bigint_col118 BIGINT,
float_col118 FLOAT,
double_col118 DOUBLE,
string_col118 STRING,
bool_col119 BOOLEAN,
tinyint_col119 TINYINT,
smallint_col119 SMALLINT,
int_col119 INT,
bigint_col119 BIGINT,
float_col119 FLOAT,
double_col119 DOUBLE,
string_col119 STRING,
bool_col120 BOOLEAN,
tinyint_col120 TINYINT,
smallint_col120 SMALLINT,
int_col120 INT,
bigint_col120 BIGINT,
float_col120 FLOAT,
double_col120 DOUBLE,
string_col120 STRING,
bool_col121 BOOLEAN,
tinyint_col121 TINYINT,
smallint_col121 SMALLINT,
int_col121 INT,
bigint_col121 BIGINT,
float_col121 FLOAT,
double_col121 DOUBLE,
string_col121 STRING,
bool_col122 BOOLEAN,
tinyint_col122 TINYINT,
smallint_col122 SMALLINT,
int_col122 INT,
bigint_col122 BIGINT,
float_col122 FLOAT,
double_col122 DOUBLE,
string_col122 STRING,
bool_col123 BOOLEAN,
tinyint_col123 TINYINT,
smallint_col123 SMALLINT,
int_col123 INT,
bigint_col123 BIGINT,
float_col123 FLOAT,
double_col123 DOUBLE,
string_col123 STRING,
bool_col124 BOOLEAN,
tinyint_col124 TINYINT,
smallint_col124 SMALLINT,
int_col124 INT,
bigint_col124 BIGINT,
float_col124 FLOAT,
double_col124 DOUBLE,
string_col124 STRING,
bool_col125 BOOLEAN,
tinyint_col125 TINYINT,
smallint_col125 SMALLINT,
int_col125 INT,
bigint_col125 BIGINT,
float_col125 FLOAT,
double_col125 DOUBLE,
string_col125 STRING
)
ROW FORMAT delimited fields terminated by ','  escaped by '\\'
STORED AS SEQUENCEFILE
LOCATION '/test-warehouse/widetable_1000_cols_seq_record_bzip'
Summary: Returned 1 rows
Success: True
Took: 3.33042001724(s)
Data:
Table has been created.

ERROR: DROP TABLE IF EXISTS functional_seq_record_bzip.insert_only_transactional_table
Traceback (most recent call last):
  File "/data/jenkins/workspace/impala-private-parameterized/repos/Impala/bin/load-data.py", line 208, in exec_impala_query_from_file
    result = impala_client.execute(query)
  File "/data/jenkins/workspace/impala-private-parameterized/repos/Impala/tests/beeswax/impala_beeswax.py", line 187, in execute
    handle = self.__execute_query(query_string.strip(), user=user)
  File "/data/jenkins/workspace/impala-private-parameterized/repos/Impala/tests/beeswax/impala_beeswax.py", line 363, in __execute_query
    handle = self.execute_query_async(query_string, user=user)
  File "/data/jenkins/workspace/impala-private-parameterized/repos/Impala/tests/beeswax/impala_beeswax.py", line 357, in execute_query_async
    handle = self.__do_rpc(lambda: self.imp_service.query(query,))
  File "/data/jenkins/workspace/impala-private-parameterized/repos/Impala/tests/beeswax/impala_beeswax.py", line 520, in __do_rpc
    raise ImpalaBeeswaxException(self.__build_error_message(b), b)
ImpalaBeeswaxException: ImpalaBeeswaxException:
 INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
 MESSAGE: ImpalaRuntimeException: Error making 'dropTable' RPC to Hive Metastore: 
CAUSED BY: MetaException: Exception thrown flushing changes to datastore