Programming makes everything

In this case I usually create Hive table with tsv file, and then analysis data with HQL query. First, you need to do is create table CREATE EXTERNAL TABLE 'database_name.table_name' ( id bigint COMMENT 'put column exactly same with tsv file header name', class string, type string, access string, category string ) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde&#3..