hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xialu (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-21411) LEFT JOIN CONVERT TO INNER JOIN LEAD TO WRONG RESULT
Date Tue, 12 Mar 2019 06:28:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-21411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16790260#comment-16790260
] 

xialu edited comment on HIVE-21411 at 3/12/19 6:27 AM:
-------------------------------------------------------

show create table lulu.store_sales;
+-----------------------------------------------------------------+--+
| createtab_stmt |
+-----------------------------------------------------------------+--+
| CREATE TABLE `lulu.store_sales`( |
| `ss_sold_time_sk` bigint, |
| `ss_item_sk` bigint, |
| `ss_customer_sk` bigint, |
| `ss_cdemo_sk` bigint, |
| `ss_hdemo_sk` bigint, |
| `ss_addr_sk` bigint, |
| `ss_store_sk` bigint, |
| `ss_promo_sk` bigint, |
| `ss_ticket_number` bigint, |
| `ss_quantity` int, |
| `ss_wholesale_cost` decimal(7,2), |
| `ss_list_price` decimal(7,2), |
| `ss_sales_price` decimal(7,2), |
| `ss_ext_discount_amt` decimal(7,2), |
| `ss_ext_sales_price` decimal(7,2), |
| `ss_ext_wholesale_cost` decimal(7,2), |
| `ss_ext_list_price` decimal(7,2), |
| `ss_ext_tax` decimal(7,2), |
| `ss_coupon_amt` decimal(7,2), |
| `ss_net_paid` decimal(7,2), |
| `ss_net_paid_inc_tax` decimal(7,2), |
| `ss_net_profit` decimal(7,2), |
| `ss_sold_date_sk` bigint) |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.mapred.TextInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' |
| LOCATION |
| 'hdfs://dev/user/warehouse/lulu.db/store_sales' |
| TBLPROPERTIES ( |
| 'COLUMN_STATS_ACCURATE'='\{\"BASIC_STATS\":\"true\"}', |
| 'numFiles'='1', |
| 'numRows'='200', |
| 'rawDataSize'='28499', |
| 'totalSize'='28699', |
| 'transient_lastDdlTime'='1551763495') |
+-----------------------------------------------------------------+--+

show create table lulu.date_dim;
+-----------------------------------------------------------------+--+
| createtab_stmt |
+-----------------------------------------------------------------+--+
| CREATE TABLE `lulu.date_dim`(
| `d_date_sk` bigint, |
| `d_date_id` string, |
| `d_date` string, |
| `d_month_seq` bigint, |
| `d_week_seq` bigint, |
| `d_quarter_seq` bigint, |
| `d_year` bigint, |
| `d_dow` bigint, |
| `d_moy` bigint, |
| `d_dom` bigint, |
| `d_qoy` bigint, |
| `d_fy_year` bigint, |
| `d_fy_quarter_seq` bigint, |
| `d_fy_week_seq` bigint, |
| `d_day_name` string, |
| `d_quarter_name` string, |
| `d_holiday` string, |
| `d_weekend` string, |
| `d_following_holiday` string, |
| `d_first_dom` bigint, |
| `d_last_dom` bigint, |
| `d_same_day_ly` bigint, |
| `d_same_day_lq` bigint, |
| `d_current_day` string, |
| `d_current_week` string, |
| `d_current_month` string, |
| `d_current_quarter` string, |
| `d_current_year` string) |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.mapred.TextInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' |
| LOCATION |
| 'hdfs://dev/user/warehouse/lulu.db/date_dim' |
| TBLPROPERTIES ( |
| 'last_modified_by'='hive', |
| 'last_modified_time'='1552359535', |
| 'numFiles'='1', |
| 'numRows'='200', |
| 'rawDataSize'='25639', |
| 'totalSize'='25839', |
| 'transient_lastDdlTime'='1552359535') |
+-----------------------------------------------------------------+--+

dataset of date_dim:
2415071^AAAAAAAAAPNJNECAA^A1900-02-20^A1^A8^A1^A1900^A1^A2^A20^A1^A1900^A1^A8^AMonday^A1900Q1^AN^AN^AN^A2415052^A2415082^A2414706^A2414979^AN^AN^AN^AN^AN
2415070^AAAAAAAAAONJNECAA^A1900-02-19^A1^A7^A1^A1900^A0^A2^A19^A1^A1900^A1^A7^ASunday^A1900Q1^AN^AN^AN^A2415052^A2415082^A2414705^A2414978^AN^AN^AN^AN^AN
2415069^AAAAAAAAANNJNECAA^A1900-02-18^A1^A7^A1^A1900^A6^A2^A18^A1^A1900^A1^A7^ASaturday^A1900Q1^AN^AY^AN^A2415052^A2415082^A2414704^A2414977^AN^AN^AN^AN^AN
2415068^AAAAAAAAAMNJNECAA^A1900-02-17^A1^A7^A1^A1900^A5^A2^A17^A1^A1900^A1^A7^AFriday^A1900Q1^AN^AY^AN^A2415052^A2415082^A2414703^A2414976^AN^AN^AN^AN^AN
2415067^AAAAAAAAALNJNECAA^A1900-02-16^A1^A7^A1^A1900^A4^A2^A16^A1^A1900^A1^A7^AThursday^A1900Q1^AN^AN^AN^A2415052^A2415082^A2414702^A2414975^AN^AN^AN^AN^AN
2415066^AAAAAAAAAKNJNECAA^A1900-02-15^A1^A7^A1^A1900^A3^A2^A15^A1^A1900^A1^A7^AWednesday^A1900Q1^AN^AN^AN^A2415052^A2415082^A2414701^A2414974^AN^AN^AN^AN^AN
2415065^AAAAAAAAAJNJNECAA^A1900-02-14^A1^A7^A1^A1900^A2^A2^A14^A1^A1900^A1^A7^ATuesday^A1900Q1^AN^AN^AN^A2415052^A2415082^A2414700^A2414973^AN^AN^AN^AN^AN
2415064^AAAAAAAAAINJNECAA^A1900-02-13^A1^A7^A1^A1900^A1^A2^A13^A1^A1900^A1^A7^AMonday^A1900Q1^AN^AN^AN^A2415052^A2415082^A2414699^A2414972^AN^AN^AN^AN^AN
2415063^AAAAAAAAAHNJNECAA^A1900-02-12^A1^A6^A1^A1900^A0^A2^A12^A1^A1900^A1^A6^ASunday^A1900Q1^AN^AN^AN^A2415052^A2415082^A2414698^A2414971^AN^AN^AN^AN^AN
2415062^AAAAAAAAAGNJNECAA^A1900-02-11^A1^A6^A1^A1900^A6^A2^A11^A1^A1900^A1^A6^ASaturday^A1900Q1^AN^AY^AN^A2415052^A2415082^A2414697^A2414970^AN^AN^AN^AN^AN
2415061^AAAAAAAAAFNJNECAA^A1900-02-10^A1^A6^A1^A1900^A5^A2^A10^A1^A1900^A1^A6^AFriday^A1900Q1^AN^AY^AN^A2415052^A2415082^A2414696^A2414969^AN^AN^AN^AN^AN

dataset of store_sales:
38657^A152701^A1750816^A248343^A1423^A932550^A286^A279^A2280617^A34^A57.58^A78.88^A50.48^A1321.56^A1716.32^A1957.72^A2681.92^A23.68^A1321.56^A394.76^A418.44^A-1562.96^A2451118
29681^A160681^A850454^A484410^A7166^A78369^A16^A910^A2279709^A44^A39.80^A39.80^A16.71^A0.00^A735.24^A1751.20^A1751.20^A58.81^A0.00^A735.24^A794.05^A-1015.96^A2451118
29681^A162896^A850454^A484410^A7166^A78369^A16^A140^A2279709^A13^A14.14^A14.98^A11.53^A0.00^A149.89^A183.82^A194.74^A13.49^A0.00^A149.89^A163.38^A-33.93^A2451118
29681^A187304^A850454^A484410^A7166^A78369^A16^A901^A2279709^A1^A55.38^A94.14^A55.54^A16.66^A55.54^A55.38^A94.14^A0.38^A16.66^A38.88^A39.26^A-16.50^A2451118
29681^A115807^A850454^A484410^A7166^A78369^A16^A811^A2279709^A53^A3.74^A4.56^A2.05^A0.00^A108.65^A198.22^A241.68^A3.25^A0.00^A108.65^A111.90^A-89.57^A2451118
29681^A145723^A850454^A484410^A7166^A78369^A16^A197^A2279709^A64^A98.01^A156.81^A112.90^A0.00^A7225.60^A6272.64^A10035.84^A0.00^A0.00^A7225.60^A7225.60^A952.96^A2451118
29681^A18254^A850454^A484410^A7166^A78369^A16^A15^A2279709^A59^A61.22^A121.82^A74.31^A306.90^A4384.29^A3611.98^A7187.38^A366.96^A306.90^A4077.39^A4444.35^A465.41^A2451118
29681^A44242^A850454^A484410^A7166^A78369^A16^A791^A2279709^A62^A73.76^A126.86^A83.72^A0.00^A5190.64^A4573.12^A7865.32^A155.71^A0.00^A5190.64^A5346.35^A617.52^A2451118
62860^A116653^A292520^A1592283^A6093^A271103^A158^A249^A2278830^A41^A43.26^A72.24^A66.46^A0.00^A2724.86^A1773.66^A2961.84^A81.74^A0.00^A2724.86^A2806.60^A951.20^A2451118
62860^A145249^A292520^A1592283^A6093^A271103^A158^A72^A2278830^A83^A98.87^A159.18^A44.57^A0.00^A3699.31^A8206.21^A13211.94^A147.97^A0.00^A3699.31^A3847.28^A-4506.90^A2451118
62860^A159622^A292520^A1592283^A6093^A271103^A158^A879^A2278830^A83^A73.61^A92.74^A52.86^A0.00^A4387.38^A6109.63^A7697.42^A43.87^A0.00^A4387.38^A4431.25^A-1722.25^A2451118


was (Author: tianmenglan2016):
[~vgarg] easy to reproduce

show create table lulu.store_sales;
+-----------------------------------------------------------------+--+
| createtab_stmt |
+-----------------------------------------------------------------+--+
| CREATE TABLE `lulu.store_sales`( |
| `ss_sold_time_sk` bigint, |
| `ss_item_sk` bigint, |
| `ss_customer_sk` bigint, |
| `ss_cdemo_sk` bigint, |
| `ss_hdemo_sk` bigint, |
| `ss_addr_sk` bigint, |
| `ss_store_sk` bigint, |
| `ss_promo_sk` bigint, |
| `ss_ticket_number` bigint, |
| `ss_quantity` int, |
| `ss_wholesale_cost` decimal(7,2), |
| `ss_list_price` decimal(7,2), |
| `ss_sales_price` decimal(7,2), |
| `ss_ext_discount_amt` decimal(7,2), |
| `ss_ext_sales_price` decimal(7,2), |
| `ss_ext_wholesale_cost` decimal(7,2), |
| `ss_ext_list_price` decimal(7,2), |
| `ss_ext_tax` decimal(7,2), |
| `ss_coupon_amt` decimal(7,2), |
| `ss_net_paid` decimal(7,2), |
| `ss_net_paid_inc_tax` decimal(7,2), |
| `ss_net_profit` decimal(7,2), |
| `ss_sold_date_sk` bigint) |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.mapred.TextInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' |
| LOCATION |
| 'hdfs://dev/user/warehouse/lulu.db/store_sales' |
| TBLPROPERTIES ( |
| 'COLUMN_STATS_ACCURATE'='\{\"BASIC_STATS\":\"true\"}', |
| 'numFiles'='1', |
| 'numRows'='200', |
| 'rawDataSize'='28499', |
| 'totalSize'='28699', |
| 'transient_lastDdlTime'='1551763495') |
+-----------------------------------------------------------------+--+

show create table lulu.date_dim;
+-----------------------------------------------------------------+--+
| createtab_stmt |
+-----------------------------------------------------------------+--+
| CREATE TABLE `lulu.date_dim`( |
| `d_date_sk` bigint, |
| `d_date_id` string, |
| `d_date` string, |
| `d_month_seq` bigint, |
| `d_week_seq` bigint, |
| `d_quarter_seq` bigint, |
| `d_year` bigint, |
| `d_dow` bigint, |
| `d_moy` bigint, |
| `d_dom` bigint, |
| `d_qoy` bigint, |
| `d_fy_year` bigint, |
| `d_fy_quarter_seq` bigint, |
| `d_fy_week_seq` bigint, |
| `d_day_name` string, |
| `d_quarter_name` string, |
| `d_holiday` string, |
| `d_weekend` string, |
| `d_following_holiday` string, |
| `d_first_dom` bigint, |
| `d_last_dom` bigint, |
| `d_same_day_ly` bigint, |
| `d_same_day_lq` bigint, |
| `d_current_day` string, |
| `d_current_week` string, |
| `d_current_month` string, |
| `d_current_quarter` string, |
| `d_current_year` string, |
| `click_transfer` int COMMENT '点击转化', |
| `order` int COMMENT '购买转化', |
| `click_order` int COMMENT '点击购买转化', |
| `order_transfer` int COMMENT '购买黑卡转化', |
| `click_order_transfer` int COMMENT '点击购买黑卡转化', |
| `click_transfer_1` int COMMENT '点击转化', |
| `order_1` int COMMENT '购买转化', |
| `click_order_1` int COMMENT '点击购买转化', |
| `order_transfer_1` int COMMENT '购买黑卡转化', |
| `click_order_transfer_1` int COMMENT '点击购买黑卡转化') |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.mapred.TextInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' |
| LOCATION |
| 'hdfs://dev/user/warehouse/lulu.db/date_dim' |
| TBLPROPERTIES ( |
| 'last_modified_by'='hive', |
| 'last_modified_time'='1552359535', |
| 'numFiles'='1', |
| 'numRows'='200', |
| 'rawDataSize'='25639', |
| 'totalSize'='25839', |
| 'transient_lastDdlTime'='1552359535') |
+-----------------------------------------------------------------+--+

data of date_dim:
2415221^AAAAAAAAAFHKNECAA^A1900-07-20^A6^A29^A3^A1900^A5^A7^A20^A3^A1900^A3^A29^AFriday^A1900Q3^AN^AY^AN^A2415202^A2415383^A2414856^A2415130^AN^AN^AN^AN^AN
2415220^AAAAAAAAAEHKNECAA^A1900-07-19^A6^A29^A3^A1900^A4^A7^A19^A3^A1900^A3^A29^AThursday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414855^A2415129^AN^AN^AN^AN^AN
2415219^AAAAAAAAADHKNECAA^A1900-07-18^A6^A29^A3^A1900^A3^A7^A18^A3^A1900^A3^A29^AWednesday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414854^A2415128^AN^AN^AN^AN^AN
2415218^AAAAAAAAACHKNECAA^A1900-07-17^A6^A29^A3^A1900^A2^A7^A17^A3^A1900^A3^A29^ATuesday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414853^A2415127^AN^AN^AN^AN^AN
2415217^AAAAAAAAABHKNECAA^A1900-07-16^A6^A28^A3^A1900^A1^A7^A16^A3^A1900^A3^A28^AMonday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414852^A2415126^AN^AN^AN^AN^AN
2415216^AAAAAAAAAAHKNECAA^A1900-07-15^A6^A28^A3^A1900^A0^A7^A15^A3^A1900^A3^A28^ASunday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414851^A2415125^AN^AN^AN^AN^AN
2415215^AAAAAAAAAPGKNECAA^A1900-07-14^A6^A28^A3^A1900^A6^A7^A14^A3^A1900^A3^A28^ASaturday^A1900Q3^AN^AY^AN^A2415202^A2415383^A2414850^A2415124^AN^AN^AN^AN^AN
2415214^AAAAAAAAAOGKNECAA^A1900-07-13^A6^A28^A3^A1900^A5^A7^A13^A3^A1900^A3^A28^AFriday^A1900Q3^AN^AY^AN^A2415202^A2415383^A2414849^A2415123^AN^AN^AN^AN^AN
2415213^AAAAAAAAANGKNECAA^A1900-07-12^A6^A28^A3^A1900^A4^A7^A12^A3^A1900^A3^A28^AThursday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414848^A2415122^AN^AN^AN^AN^AN
2415212^AAAAAAAAAMGKNECAA^A1900-07-11^A6^A28^A3^A1900^A3^A7^A11^A3^A1900^A3^A28^AWednesday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414847^A2415121^AN^AN^AN^AN^AN
2415211^AAAAAAAAALGKNECAA^A1900-07-10^A6^A28^A3^A1900^A2^A7^A10^A3^A1900^A3^A28^ATuesday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414846^A2415120^AN^AN^AN^AN^AN
2415210^AAAAAAAAAKGKNECAA^A1900-07-09^A6^A27^A3^A1900^A1^A7^A9^A3^A1900^A3^A27^AMonday^A1900Q3^AN^AN^AN^A2415202^A2415383^A2414845^A2415119^AN^AN^AN^AN^AN

data of store_sales:
38657^A152701^A1750816^A248343^A1423^A932550^A286^A279^A2280617^A34^A57.58^A78.88^A50.48^A1321.56^A1716.32^A1957.72^A2681.92^A23.68^A1321.56^A394.76^A418.44^A-1562.96^A2451118
29681^A160681^A850454^A484410^A7166^A78369^A16^A910^A2279709^A44^A39.80^A39.80^A16.71^A0.00^A735.24^A1751.20^A1751.20^A58.81^A0.00^A735.24^A794.05^A-1015.96^A2451118
29681^A162896^A850454^A484410^A7166^A78369^A16^A140^A2279709^A13^A14.14^A14.98^A11.53^A0.00^A149.89^A183.82^A194.74^A13.49^A0.00^A149.89^A163.38^A-33.93^A2451118
29681^A187304^A850454^A484410^A7166^A78369^A16^A901^A2279709^A1^A55.38^A94.14^A55.54^A16.66^A55.54^A55.38^A94.14^A0.38^A16.66^A38.88^A39.26^A-16.50^A2451118
29681^A115807^A850454^A484410^A7166^A78369^A16^A811^A2279709^A53^A3.74^A4.56^A2.05^A0.00^A108.65^A198.22^A241.68^A3.25^A0.00^A108.65^A111.90^A-89.57^A2451118
29681^A145723^A850454^A484410^A7166^A78369^A16^A197^A2279709^A64^A98.01^A156.81^A112.90^A0.00^A7225.60^A6272.64^A10035.84^A0.00^A0.00^A7225.60^A7225.60^A952.96^A2451118
29681^A18254^A850454^A484410^A7166^A78369^A16^A15^A2279709^A59^A61.22^A121.82^A74.31^A306.90^A4384.29^A3611.98^A7187.38^A366.96^A306.90^A4077.39^A4444.35^A465.41^A2451118
29681^A44242^A850454^A484410^A7166^A78369^A16^A791^A2279709^A62^A73.76^A126.86^A83.72^A0.00^A5190.64^A4573.12^A7865.32^A155.71^A0.00^A5190.64^A5346.35^A617.52^A2451118
62860^A116653^A292520^A1592283^A6093^A271103^A158^A249^A2278830^A41^A43.26^A72.24^A66.46^A0.00^A2724.86^A1773.66^A2961.84^A81.74^A0.00^A2724.86^A2806.60^A951.20^A2451118
62860^A145249^A292520^A1592283^A6093^A271103^A158^A72^A2278830^A83^A98.87^A159.18^A44.57^A0.00^A3699.31^A8206.21^A13211.94^A147.97^A0.00^A3699.31^A3847.28^A-4506.90^A2451118
62860^A159622^A292520^A1592283^A6093^A271103^A158^A879^A2278830^A83^A73.61^A92.74^A52.86^A0.00^A4387.38^A6109.63^A7697.42^A43.87^A0.00^A4387.38^A4431.25^A-1722.25^A2451118

> LEFT JOIN CONVERT TO INNER JOIN LEAD TO WRONG RESULT
> ----------------------------------------------------
>
>                 Key: HIVE-21411
>                 URL: https://issues.apache.org/jira/browse/HIVE-21411
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 2.1.1, 2.2.0, 2.3.0
>            Reporter: xialu
>            Assignee: Ashutosh Chauhan
>            Priority: Critical
>
> when i have not assign alias table name to the left side table , left join convert to
inner join. left side table's alias in ast tree called left.
>  for example
> select nvl(ss_wholesale_cost, 10), d_quarter_name from lulu.store_sales left join lulu.date_dim
on ss_sold_date_sk = d_date_sk limit 10;
> {noformat}
> | STAGE DEPENDENCIES: |
> | Stage-1 is a root stage |
> | Stage-0 depends on stages: Stage-1 |
> | |
> | STAGE PLANS: |
> | Stage: Stage-1 |
> | Map Reduce |
> | Map Operator Tree: |
> | TableScan |
> | alias: left |
> | Statistics: Num rows: 200 Data size: 28499 Basic stats: COMPLETE Column stats: NONE
|
> | Filter Operator |
> | predicate: ss_sold_date_sk is not null (type: boolean) |
> | Statistics: Num rows: 200 Data size: 28499 Basic stats: COMPLETE Column stats: NONE
|
> | Select Operator |
> | expressions: ss_wholesale_cost (type: decimal(7,2)), ss_sold_date_sk (type: bigint)
|
> | outputColumnNames: _col0, _col1 |
> | Statistics: Num rows: 200 Data size: 28499 Basic stats: COMPLETE Column stats: NONE
|
> | Reduce Output Operator |
> | key expressions: _col1 (type: bigint) |
> | sort order: + |
> | Map-reduce partition columns: _col1 (type: bigint) |
> | Statistics: Num rows: 200 Data size: 28499 Basic stats: COMPLETE Column stats: NONE
|
> | value expressions: _col0 (type: decimal(7,2)) |
> | TableScan |
> | alias: date_dim |
> | Statistics: Num rows: 200 Data size: 25639 Basic stats: COMPLETE Column stats: NONE
|
> | Filter Operator |
> | predicate: d_date_sk is not null (type: boolean) |
> | Statistics: Num rows: 200 Data size: 25639 Basic stats: COMPLETE Column stats: NONE
|
> | Select Operator |
> | expressions: d_date_sk (type: bigint), d_quarter_name (type: string) |
> | outputColumnNames: _col0, _col1 |
> | Statistics: Num rows: 200 Data size: 25639 Basic stats: COMPLETE Column stats: NONE
|
> | Reduce Output Operator |
> | key expressions: _col0 (type: bigint) |
> | sort order: + |
> | Map-reduce partition columns: _col0 (type: bigint) |
> | Statistics: Num rows: 200 Data size: 25639 Basic stats: COMPLETE Column stats: NONE
|
> | value expressions: _col1 (type: string) |
> | Reduce Operator Tree: |
> | Join Operator |
> | condition map: |
> | Inner Join 0 to 1 |
> | keys: |
> | 0 _col1 (type: bigint) |
> | 1 _col0 (type: bigint) |
> | outputColumnNames: _col0, _col3 |
> | Statistics: Num rows: 220 Data size: 31348 Basic stats: COMPLETE Column stats: NONE
|
> | Select Operator |
> | expressions: NVL(_col0,10) (type: decimal(12,2)), _col3 (type: string) |
> | outputColumnNames: _col0, _col1 |
> | Statistics: Num rows: 220 Data size: 31348 Basic stats: COMPLETE Column stats: NONE
|
> | Limit |
> | Number of rows: 100 |
> | Statistics: Num rows: 100 Data size: 14200 Basic stats: COMPLETE Column stats: NONE
|
> | File Output Operator |
> | compressed: false |
> | Statistics: Num rows: 100 Data size: 14200 Basic stats: COMPLETE Column stats: NONE
|
> | table: |
> | input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
> | output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
> | serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
> | |
> | Stage: Stage-0 |
> | Fetch Operator |
> | limit: 100 |
> | Processor Tree: |
> | ListSink |
> | |
> +--------------------------------------------------------------------------------------------------------+--+
> {noformat}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message