My first step was to create an ORC table on Hive with the same schema as the one imported on hdp : CREATE TABLE IF NOT EXISTS orcemployees( emp_no int, birth_date date,
first_name string, last_name string, gender string, hire_date date)
STORED AS ORC; My second step was to copy the data from employees into orcemployees: insert into table orcemployees select * from employees; The problem is when I execute select * from orcemployees; the schema is displayed and not the associated data.
... View more
