5.4.1Spark和Hive集成(MySql)

1
2
3
4
5
<property>
<name>hive.metastore.uris</name>
<value>thrift://master:9083</value>
     <description>Thrift uri for the remote metastore. Used bymetastore client to connect to remote metastore.</description>
</property>

1
命令：hive --service metastore &

1
命令：jobs

1
2
命令：kill
%1

1
2
CREATE TABLE
PERSON(NAME STRING,WORK_LOCATIONSARRAY<STRING>) ROW FORMAT DELIMITED FIELDS TERMINATED BY 't' COLLECTIONITEMS TERMINATED BY ',';

1
LOAD DATA LOCAL INPATH '/usr/apps/testsource/person.txt'OVERWRITE INTO TABLE person;

1
CREATE TABLETEST01.SCORE(NAME STRING, SCORE MAP<STRING,INT>) ROW FORMAT DELIMITEDFIELDS TERMINATED BY 't' COLLECTION ITEMS TERMINATED BY ',' MAP KEYS TERMINATEDBY ':';

1
LOAD DATA LOCALINPATH '/usr/apps/testsource/score.txt' OVERWRITE INTO TABLE test01.score;

1
查询：select * from score;

1
select * from test01.score;