u013494310的专栏

//HEADER HQLCREATE EXTERNAL TABLE HeaderROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'STORED ASINPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'OUTPUTFORM

创建一个内部表：create database

org.apache.phoenix phoenix-core 4.0.0-incubating provided

HADOOP_CLIENT_DIR=/opt/cloudera/parcels/CDH/lib/hadoop/client/HIVE_LIB_DIR=/opt/cloudera/parcels/CDH/lib/hive/libIMPALA_LIB_DIR=/opt/cloudera/parcels/CDH/lib/impala/libCLASSPATH=$HIVE_LIB_DIR/hive

package com.cloudera.example;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class ClouderaImpa

a

use mwd;--prepare data, c_ip 为左补足0转换后值-- ETL: spv datacreate temporary function row_sequence as 'com.mwd.hive.udf.RowSequence';create temporary function parse_agent as 'com.mwd.hive.udf.Hdfs

创建表： hive> CREATE TABLE pokes (foo INT,bar STRING); hive> CREATE TABLE invites (foo INT,bar STRING) PARTITIONED BY (ds STRING);查看表： SHOW TABLES;查看列： DESCRIBE invites;修改表：hive> ALTER TABL

hive sql 学习笔记(1)一、 创建表     在官方的wiki里，example是这样的：Sql代码  CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name    [(col_name data_type [COMMENT col_comment], ...)]    [COMMENT tabl

这里罗列常用操作，更多参考 https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create%2FDrop%2FTruncateTable 简单的创建表create table table_name ( id int,