Hive 3.1.2 운용 연습

 대부분 MySQL 명령어와 유사

1. 파일로 입력하기 

hdfs dfs -put names.txt text

> show databases;

> create database testdb;

> use testdb;

> CREATE EXTERNAL TABLE IF NOT EXISTS names(

EmployeeID INT, FirstName STRING, Title STRING, State STRING, Laptop STRING)

COMMENT 'Employee Names'

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ','

STORED AS TEXTFILE

location '/user/bjyoo/text';

>select * from names;

지우기 

>drop table names;

>drop database testdb;

>exit;