CREATE external TABLE IF NOT EXISTS sessions
(
session_id string,
uid bigint,
uids array<bigint>,
search_ids array<string>,
total_views int,
datestamp date
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE
LOCATION '../../data/files/arrayofIntdata';

CREATE TABLE IF NOT EXISTS sessions_orc
(
session_id string,
uid bigint,
uids array<bigint>,
search_ids array<string>,
total_views int,
datestamp date
);

describe formatted sessions_orc;

INSERT OVERWRITE TABLE sessions_orc
SELECT * FROM sessions;

select count(1) from sessions_orc;
select count(1) from sessions;
drop table sessions;
drop table sessions_orc;