====
---- QUERY
create table $DATABASE.temp_decimal_table_orc like ORC
'$FILESYSTEM_PREFIX/test-warehouse/decimal_tiny_orc_def/000000_0'
---- RESULTS
'Table has been created.'
====
---- QUERY
describe $DATABASE.temp_decimal_table_orc
---- RESULTS
'c1','decimal(10,4)','Inferred from ORC file.'
'c2','decimal(15,5)','Inferred from ORC file.'
'c3','decimal(1,1)','Inferred from ORC file.'
---- TYPES
STRING, STRING, STRING
====
---- QUERY
create table $DATABASE.temp_chars_table like ORC
'$FILESYSTEM_PREFIX/test-warehouse/chars_tiny_orc_def/000000_0'
---- RESULTS
'Table has been created.'
====
---- QUERY
describe $DATABASE.temp_chars_table
---- RESULTS
'cs','char(5)','Inferred from ORC file.'
'cl','char(140)','Inferred from ORC file.'
'vc','varchar(32)','Inferred from ORC file.'
---- TYPES
STRING, STRING, STRING
====
---- QUERY
create table $DATABASE.like_zipcodes_file_orc like ORC
'$FILESYSTEM_PREFIX/test-warehouse/zipcode_incomes_orc_def/000000_0'
---- RESULTS
'Table has been created.'
====
---- QUERY
describe $DATABASE.like_zipcodes_file_orc
---- RESULTS
'id','string','Inferred from ORC file.'
'zip','string','Inferred from ORC file.'
'description1','string','Inferred from ORC file.'
'description2','string','Inferred from ORC file.'
'income','int','Inferred from ORC file.'
---- TYPES
STRING, STRING, STRING
====
---- QUERY
create table $DATABASE.like_alltypestiny_file_orc like ORC
'$FILESYSTEM_PREFIX/test-warehouse/alltypestiny_orc_def/year=2009/month=1/000000_0'
---- RESULTS
'Table has been created.'
====
---- QUERY
describe $DATABASE.like_alltypestiny_file_orc
---- RESULTS
'id','int','Inferred from ORC file.'
'bool_col','boolean','Inferred from ORC file.'
'tinyint_col','tinyint','Inferred from ORC file.'
'smallint_col','smallint','Inferred from ORC file.'
'int_col','int','Inferred from ORC file.'
'bigint_col','bigint','Inferred from ORC file.'
'float_col','float','Inferred from ORC file.'
'double_col','double','Inferred from ORC file.'
'date_string_col','string','Inferred from ORC file.'
'string_col','string','Inferred from ORC file.'
'timestamp_col','timestamp','Inferred from ORC file.'
---- TYPES
STRING, STRING, STRING
====
---- QUERY
create table allcomplextypes_clone_orc like ORC
'$FILESYSTEM_PREFIX/test-warehouse/complextypestbl_orc_def/nullable.orc'
---- RESULTS
'Table has been created.'
====
---- QUERY
describe allcomplextypes_clone_orc
---- RESULTS
'id','bigint','Inferred from ORC file.'
'int_array','array<int>','Inferred from ORC file.'
'int_array_array','array<array<int>>','Inferred from ORC file.'
'int_map','map<string,int>','Inferred from ORC file.'
'int_map_array','array<map<string,int>>','Inferred from ORC file.'
'nested_struct','struct<\n  a:int,\n  b:array<int>,\n  c:struct<\n    d:array<array<struct<\n      e:int,\n      f:string\n    >>>\n  >,\n  g:map<string,struct<\n    h:struct<\n      i:array<double>\n    >\n  >>\n>','Inferred from ORC file.'
---- TYPES
STRING, STRING, STRING
====