【云计算】impala建表,文件关联,查询
[cll@hadoop164 cxf]$ hdfs dfs -mkdir -p /csv-pig/tab1 /csv-pig/tab1
tab1.csv:
1,true,123.123,2012-10-24 08:55:00
2,false,1243.5,2012-10-25 13:40:00
3,false,24453.325,2008-08-22 09:33:21.123
4,false,243423.325,2007-05-12 22:32:21.33454
5,true,243.325,1953-04-22 09:11:33
[cll@hadoop164 cxf]$ hdfs dfs -put tab1.csv /csv-pig/tab1
DROP TABLE IF EXISTS tab1;
-- The EXTERNAL clause means the data is located outside the central location for Impala data files
-- and is preserved when the associated Impala table is dropped. We expect the data to already
-- exist in the directory specified by the LOCATION clause.
CREATE EXTERNAL TABLE tab1
(
id INT,
col_1 BOOLEAN,
col_2 DOUBLE,
col_3 TIMESTAMP
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
LOCATION '/csv-pig/tab1';
-- 如果分区
PARTITIONED BY (
startdate STRING
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
WITH SERDEPROPERTIES ('serialization.format'='|', 'field.delim'='|')
STORED AS TEXTFILE
LOCATION '/csv-pig/gbiupsdns'
ALTER TABLE expweixin ADD PARTITION (startdate='2014103002');
-- 如果权限
sudo -u hdfs hdfs dfs -chown -R impala:hive /csv-pig/expweixin
impala-shell -i 172.16.230.152 -f table_setup.sql
最新文章
- vi 颜色配置
- win7 双屏双任务栏
- 关于MFC文本框输入内容的获取 与 设置文本框的内容
- 最小/大费用最大流模板(codevs1914)
- -bash: sudo: command not found Error and Solution
- 老生常谈,正确使用memset
- Python多进程(1)——subprocess与Popen()
- LightOj 1163 - Bank Robbery(x-x/10 = n求所有的 x )
- word2007如何进行批注
- jpg图片在IE6、IE7和IE8下不显示解决办法
- ED/EP简介
- cuda-convnet 卷积神经网络 一般性结构卷积核个数 和 输入输出的关系以及输入输出的个数的说明:
- Java 向Hbase表插入数据报(org.apache.hadoop.hbase.client.HTablePool$PooledHTable cannot be cast to org.apac)
- 最简单的基于FFmpeg的移动端例子:IOS 视频转码器
- 网易云课堂_程序设计入门-C语言_第三周:循环_1奇偶个数
- 老李推荐:第14章3节《MonkeyRunner源码剖析》 HierarchyViewer实现原理-HierarchyViewer实例化
- linux 服务器命令
- nginx支持跨域访问
- [pat]1068 Find More Coins
- 使用fastdfs搭建文件服务器