wangxiaopeng0329的博客

select … from clause:1.1array类型： hive> SELECT name, subordinates FROM employees;John Doe  ["Mary Smith","Todd Jones"]Todd Jones  []--( ‘subordinates’为array类型，并且字符串带有双引号。)hive> SELECT nam

1.views odds and ends( the conceptual view still applies when the view and a query that uses it both contain an  ORDER BY clause or a  LIMIT clause. The view’s clauses are evaluated before the usin

²  Data Manipulation1. Loading Data into Managed Tables:LOAD DATA [ LOCAL ] INPATH '${env:HOME}/california-employees'[ OVERWRITE ] INTO TABLEemployeesPARTITION (country = 'US', state = 'CA

Data Definition1.创建数据库：CREATE DATABASE IF NOT EXISTS foo[LOCATION]'/m/j/jkl'  [COMMENT]'haha' [WITH DBPROPERTIES]  ('creator' = 'Mark', 'date' = '2012-01-02');**************  --(分布式默认LO

Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient at org.apache.hadoop.