MongoDB各个64位版本下载地址:
http://dl.mongodb.org/dl/win32/x86_64
my-paths.pth file (as described here). This is just a file with the extension .pth that you put into your system site-packages
在site-packages中添加一个文件my-paths.pth,其中pth文件中添加自己的模块地址就行了CREATE EXTERNAL TABLE test (
foo string,
time string,
bar string
) PARTITIONED BY (dt string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LOCATION 's3://test.com/';
建表方式如上,当然,orcfile的terminated by ',',另外需要加上一句STORED AS ORC就可以了
然后每天的天分区需要这样加载进去,才能被查询到
LTER TABLE test ADD PARTITION (dt='2014-03-05') location 's3://test.com/2014-03-05'方法参考http://stackoverflow.com/questions/22220837/how-to-add-partition-using-hive-by-a-specific-date
ref
https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_alter_table.html
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL