Hadoop Scribe nginxphp Data Warehousing at Facebook Web
Sign up to view full document!
SIGN UP
暴风Hadoop集群架构流程 Scribe nginx+php
Data Warehousing at Facebook Web Servers Scribe Servers Filers Oracle RAC Hive on Hadoop Cluster Federated My. SQL
What is Hive
Installation and Configuration • 安装和配置hadoop集群 • 下� hive 安装包 • 解� 至安装目� • 配置HADOOP_HOME和JAVA_HOME� 量 • 修改存� 元数据的数据� (derby、mysql、 oracle)
Installation and Configuration • • hive 的元数据存�
DDL and DML Operations • • hive建表� 法格式
DDL and DML Operations • • hive建表� 句 CREATE TABLE page_view (view. Time INT, userid BIGINT, page_url STRING, referrer_url STRING, ip STRING COMMENT 'IP Address of the User') COMMENT 'This is the page view table' PARTITIONED BY(dt STRING, country STRING) CLUSTERED BY(userid) SORTED BY(view. Time) INTO 32 BUCKETS ROW FORMAT DELIMITED FIELDS TERMINATED BY '