Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4546489E3 for ; Fri, 12 Aug 2011 06:06:43 +0000 (UTC) Received: (qmail 69390 invoked by uid 500); 12 Aug 2011 06:06:42 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 69200 invoked by uid 500); 12 Aug 2011 06:06:23 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 69182 invoked by uid 99); 12 Aug 2011 06:06:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Aug 2011 06:06:20 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of hadoop_wu@163.com designates 220.181.13.70 as permitted sender) Received: from [220.181.13.70] (HELO m13-70.163.com) (220.181.13.70) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Aug 2011 06:06:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Received:Date:From:To:Message-ID:Subject: MIME-Version:Content-Type; bh=WfXLXbGrXlLkFoUYesmEsHrL8h6eaBtwJ/ uqOuYI2q4=; b=AKX+wOT6ibEWEk/YZLMz3ummm+pDdULR3/B4v+0YnAsWntL64Y YDl6IxbU7VXPTe/ZWbCd51eKYgXp+1A4X5mU9JOzGkKBoWHmb9AueigAC3z1Q8QG 2ly1aL2t069R+ZbSoh8YF09KfS6qa44U6zT2gWL2nHQVIh6J6mDUkrJLA= Received: from hadoop_wu ( [180.168.100.122] ) by ajax-webmail-wmsvr70 (Coremail) ; Fri, 12 Aug 2011 14:05:48 +0800 (CST) Date: Fri, 12 Aug 2011 14:05:48 +0800 (CST) From: "Daniel,Wu" To: hive Message-ID: <36bec257.12afe.131bc98b1bb.Coremail.hadoop_wu@163.com> Subject: create table for hive MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_246086_567709747.1313129148859" X-Originating-IP: [180.168.100.122] X-Priority: 3 X-Mailer: Coremail Webmail Server Version SP_ntes V3.5 build 110713(13936.3901.3890) Copyright (c) 2002-2011 www.mailtech.cn 163com X-CM-CTRLDATA: 7bwjRmZvb3Rlcl9odG09MTM4Mzo4MQ== X-CM-TRANSID: RsGowJD7HK29wkRO0PMyAA--.1254W X-CM-SenderInfo: 5kdg00psbz3qqrwthudrp/xtbB0AGZ6UtUmyigvwACsQ X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== ------=_Part_246086_567709747.1313129148859 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: 7bit drop table store_sales; CREATE TABLE store_sales( SUBVENDOR_ID_KEY int , VENDOR_KEY int , RETAILER_KEY int , ITEM_KEY int , STORE_KEY int , SubvendorId string, OOS_REASON_KEY int , Total_Sales_Amount float , Total_Sales_Volume_Units float , Store_On_Hand_Volume_Units float , Promoted_Sales_Amount float , Promoted_Sales_Volume_Units float , Regular_Sales_Amount float , Regular_Sales_Volume_Units float , Store_Ordered_Volume_Units float , Store_Ordered_Volume_Cases float , Store_Receipts_Volume_Units float , Store_Receipts_Volume_Cases float , productline string, Store_On_Hand_Amount float , Store_On_Hand_Volume_Cases float , Total_Sales_Volume_Cases float , DC_RETAILER_KEY int , DC_KEY int , Total_Price float , Promoted_Price float , Regular_Price float , Zero_Scan_Day int , Ordered_Date int , Receipt_Date int , OOS_Indicator int , Scan_Date int , Store_On_Hand_Volume float , Conversion float ) PARTITIONED BY (PERIOD_KEY STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; ------=_Part_246086_567709747.1313129148859 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: 7bit

drop table store_sales;
CREATE TABLE store_sales(
SUBVENDOR_ID_KEY int ,
VENDOR_KEY int ,
RETAILER_KEY int ,
ITEM_KEY int ,
STORE_KEY int ,
SubvendorId string,
OOS_REASON_KEY int ,
Total_Sales_Amount float ,
Total_Sales_Volume_Units float ,
Store_On_Hand_Volume_Units float ,
Promoted_Sales_Amount float ,
Promoted_Sales_Volume_Units float ,
Regular_Sales_Amount float ,
Regular_Sales_Volume_Units float ,
Store_Ordered_Volume_Units float ,
Store_Ordered_Volume_Cases float ,
Store_Receipts_Volume_Units float ,
Store_Receipts_Volume_Cases float ,
productline string,
Store_On_Hand_Amount float ,
Store_On_Hand_Volume_Cases float ,
Total_Sales_Volume_Cases float ,
DC_RETAILER_KEY int ,
DC_KEY i nt ,
Total_Price float ,
Promoted_Price float ,
Regular_Price float ,
Zero_Scan_Day int ,
Ordered_Date int ,
Receipt_Date int ,
OOS_Indicator int ,
Scan_Date int ,
Store_On_Hand_Volume float ,
Conversion float
) PARTITIONED BY (PERIOD_KEY STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';

------=_Part_246086_567709747.1313129148859--