Added: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_count_distinct.q.out URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_count_distinct.q.out?rev=1629273&view=auto ============================================================================== --- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_count_distinct.q.out (added) +++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_count_distinct.q.out Fri Oct 3 18:00:41 2014 @@ -0,0 +1,1366 @@ +PREHOOK: query: create table web_sales_txt +( + ws_sold_date_sk int, + ws_sold_time_sk int, + ws_ship_date_sk int, + ws_item_sk int, + ws_bill_customer_sk int, + ws_bill_cdemo_sk int, + ws_bill_hdemo_sk int, + ws_bill_addr_sk int, + ws_ship_customer_sk int, + ws_ship_cdemo_sk int, + ws_ship_hdemo_sk int, + ws_ship_addr_sk int, + ws_web_page_sk int, + ws_web_site_sk int, + ws_ship_mode_sk int, + ws_warehouse_sk int, + ws_promo_sk int, + ws_order_number int, + ws_quantity int, + ws_wholesale_cost decimal(7,2), + ws_list_price decimal(7,2), + ws_sales_price decimal(7,2), + ws_ext_discount_amt decimal(7,2), + ws_ext_sales_price decimal(7,2), + ws_ext_wholesale_cost decimal(7,2), + ws_ext_list_price decimal(7,2), + ws_ext_tax decimal(7,2), + ws_coupon_amt decimal(7,2), + ws_ext_ship_cost decimal(7,2), + ws_net_paid decimal(7,2), + ws_net_paid_inc_tax decimal(7,2), + ws_net_paid_inc_ship decimal(7,2), + ws_net_paid_inc_ship_tax decimal(7,2), + ws_net_profit decimal(7,2) +) +row format delimited fields terminated by '|' +stored as textfile +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@web_sales_txt +POSTHOOK: query: create table web_sales_txt +( + ws_sold_date_sk int, + ws_sold_time_sk int, + ws_ship_date_sk int, + ws_item_sk int, + ws_bill_customer_sk int, + ws_bill_cdemo_sk int, + ws_bill_hdemo_sk int, + ws_bill_addr_sk int, + ws_ship_customer_sk int, + ws_ship_cdemo_sk int, + ws_ship_hdemo_sk int, + ws_ship_addr_sk int, + ws_web_page_sk int, + ws_web_site_sk int, + ws_ship_mode_sk int, + ws_warehouse_sk int, + ws_promo_sk int, + ws_order_number int, + ws_quantity int, + ws_wholesale_cost decimal(7,2), + ws_list_price decimal(7,2), + ws_sales_price decimal(7,2), + ws_ext_discount_amt decimal(7,2), + ws_ext_sales_price decimal(7,2), + ws_ext_wholesale_cost decimal(7,2), + ws_ext_list_price decimal(7,2), + ws_ext_tax decimal(7,2), + ws_coupon_amt decimal(7,2), + ws_ext_ship_cost decimal(7,2), + ws_net_paid decimal(7,2), + ws_net_paid_inc_tax decimal(7,2), + ws_net_paid_inc_ship decimal(7,2), + ws_net_paid_inc_ship_tax decimal(7,2), + ws_net_profit decimal(7,2) +) +row format delimited fields terminated by '|' +stored as textfile +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@web_sales_txt +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/web_sales_2k' OVERWRITE INTO TABLE web_sales_txt +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@web_sales_txt +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/web_sales_2k' OVERWRITE INTO TABLE web_sales_txt +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@web_sales_txt +PREHOOK: query: ------------------------------------------------------------------------------------------ + +create table web_sales +( + ws_sold_date_sk int, + ws_sold_time_sk int, + ws_ship_date_sk int, + ws_item_sk int, + ws_bill_customer_sk int, + ws_bill_cdemo_sk int, + ws_bill_hdemo_sk int, + ws_bill_addr_sk int, + ws_ship_customer_sk int, + ws_ship_cdemo_sk int, + ws_ship_hdemo_sk int, + ws_ship_addr_sk int, + ws_web_page_sk int, + ws_ship_mode_sk int, + ws_warehouse_sk int, + ws_promo_sk int, + ws_order_number int, + ws_quantity int, + ws_wholesale_cost decimal(7,2), + ws_list_price decimal(7,2), + ws_sales_price decimal(7,2), + ws_ext_discount_amt decimal(7,2), + ws_ext_sales_price decimal(7,2), + ws_ext_wholesale_cost decimal(7,2), + ws_ext_list_price decimal(7,2), + ws_ext_tax decimal(7,2), + ws_coupon_amt decimal(7,2), + ws_ext_ship_cost decimal(7,2), + ws_net_paid decimal(7,2), + ws_net_paid_inc_tax decimal(7,2), + ws_net_paid_inc_ship decimal(7,2), + ws_net_paid_inc_ship_tax decimal(7,2), + ws_net_profit decimal(7,2) +) +partitioned by +( + ws_web_site_sk int +) +stored as orc +tblproperties ("orc.stripe.size"="33554432", "orc.compress.size"="16384") +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@web_sales +POSTHOOK: query: ------------------------------------------------------------------------------------------ + +create table web_sales +( + ws_sold_date_sk int, + ws_sold_time_sk int, + ws_ship_date_sk int, + ws_item_sk int, + ws_bill_customer_sk int, + ws_bill_cdemo_sk int, + ws_bill_hdemo_sk int, + ws_bill_addr_sk int, + ws_ship_customer_sk int, + ws_ship_cdemo_sk int, + ws_ship_hdemo_sk int, + ws_ship_addr_sk int, + ws_web_page_sk int, + ws_ship_mode_sk int, + ws_warehouse_sk int, + ws_promo_sk int, + ws_order_number int, + ws_quantity int, + ws_wholesale_cost decimal(7,2), + ws_list_price decimal(7,2), + ws_sales_price decimal(7,2), + ws_ext_discount_amt decimal(7,2), + ws_ext_sales_price decimal(7,2), + ws_ext_wholesale_cost decimal(7,2), + ws_ext_list_price decimal(7,2), + ws_ext_tax decimal(7,2), + ws_coupon_amt decimal(7,2), + ws_ext_ship_cost decimal(7,2), + ws_net_paid decimal(7,2), + ws_net_paid_inc_tax decimal(7,2), + ws_net_paid_inc_ship decimal(7,2), + ws_net_paid_inc_ship_tax decimal(7,2), + ws_net_profit decimal(7,2) +) +partitioned by +( + ws_web_site_sk int +) +stored as orc +tblproperties ("orc.stripe.size"="33554432", "orc.compress.size"="16384") +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@web_sales +PREHOOK: query: insert overwrite table web_sales +partition (ws_web_site_sk) +select ws_sold_date_sk, ws_sold_time_sk, ws_ship_date_sk, ws_item_sk, + ws_bill_customer_sk, ws_bill_cdemo_sk, ws_bill_hdemo_sk, ws_bill_addr_sk, + ws_ship_customer_sk, ws_ship_cdemo_sk, ws_ship_hdemo_sk, ws_ship_addr_sk, + ws_web_page_sk, ws_ship_mode_sk, ws_warehouse_sk, ws_promo_sk, ws_order_number, + ws_quantity, ws_wholesale_cost, ws_list_price, ws_sales_price, ws_ext_discount_amt, + ws_ext_sales_price, ws_ext_wholesale_cost, ws_ext_list_price, ws_ext_tax, + ws_coupon_amt, ws_ext_ship_cost, ws_net_paid, ws_net_paid_inc_tax, ws_net_paid_inc_ship, + ws_net_paid_inc_ship_tax, ws_net_profit, ws_web_site_sk from web_sales_txt +PREHOOK: type: QUERY +PREHOOK: Input: default@web_sales_txt +PREHOOK: Output: default@web_sales +POSTHOOK: query: insert overwrite table web_sales +partition (ws_web_site_sk) +select ws_sold_date_sk, ws_sold_time_sk, ws_ship_date_sk, ws_item_sk, + ws_bill_customer_sk, ws_bill_cdemo_sk, ws_bill_hdemo_sk, ws_bill_addr_sk, + ws_ship_customer_sk, ws_ship_cdemo_sk, ws_ship_hdemo_sk, ws_ship_addr_sk, + ws_web_page_sk, ws_ship_mode_sk, ws_warehouse_sk, ws_promo_sk, ws_order_number, + ws_quantity, ws_wholesale_cost, ws_list_price, ws_sales_price, ws_ext_discount_amt, + ws_ext_sales_price, ws_ext_wholesale_cost, ws_ext_list_price, ws_ext_tax, + ws_coupon_amt, ws_ext_ship_cost, ws_net_paid, ws_net_paid_inc_tax, ws_net_paid_inc_ship, + ws_net_paid_inc_ship_tax, ws_net_profit, ws_web_site_sk from web_sales_txt +POSTHOOK: type: QUERY +POSTHOOK: Input: default@web_sales_txt +POSTHOOK: Output: default@web_sales@ws_web_site_sk=1 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=10 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=11 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=12 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=13 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=14 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=15 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=16 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=17 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=18 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=19 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=2 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=20 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=21 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=22 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=23 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=24 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=25 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=26 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=27 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=28 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=29 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=3 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=30 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=4 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=5 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=6 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=7 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=8 +POSTHOOK: Output: default@web_sales@ws_web_site_sk=9 +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=10).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=11).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=12).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=13).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=14).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=15).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=16).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=17).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=18).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=19).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=1).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=20).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_net_paid_inc_ship_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_net_paid_inc_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_net_profit SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_profit, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_order_number SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_order_number, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_promo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_promo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_quantity SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_quantity, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ship_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ship_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ship_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ship_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ship_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_ship_mode_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ship_mode_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_sold_date_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_date_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_sold_time_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_sold_time_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_warehouse_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_warehouse_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_web_page_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_web_page_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=21).ws_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_bill_addr_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_addr_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_bill_cdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_cdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_bill_customer_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_customer_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_bill_hdemo_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_bill_hdemo_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_coupon_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_coupon_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_ext_discount_amt SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_discount_amt, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_ext_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_ext_sales_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_sales_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_ext_ship_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_ship_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_ext_tax SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_tax, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_ext_wholesale_cost SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_ext_wholesale_cost, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_item_sk SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_item_sk, type:int, comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_list_price SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_list_price, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_net_paid SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid, type:decimal(7,2), comment:null), ] +POSTHOOK: Lineage: web_sales PARTITION(ws_web_site_sk=22).ws_net_paid_inc_ship SIMPLE [(web_sales_txt)web_sales_txt.FieldSchema(name:ws_net_paid_inc_ship, type:decimal(7,2), comment:null), ]
[... 682 lines stripped ...]
