[ https://issues.apache.org/jira/browse/HIVE-13735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15329101#comment-15329101 ]
Takuma Wakamori commented on HIVE-13735: ---------------------------------------- Hi, [~rajesh.balamohan]. If there is no one working on this issue, I will try. However, I imagine that my solution may be ad-hoc; the corresponding code will be executed only under the condition like: (the query is select) && (have distinct clause) && (select_expr is a partitioning key) && (...). If it is OK, could anyone assign me to this issue? Thanks. > Query involving only partition columns need not launch mr/tez job > ----------------------------------------------------------------- > > Key: HIVE-13735 > URL: https://issues.apache.org/jira/browse/HIVE-13735 > Project: Hive > Issue Type: Bug > Reporter: Rajesh Balamohan > > codebase: hive master > dataset: tpc-ds 10 TB scale > e.g queries: > {noformat} > hive> show partitions web_sales; > ... > ... > Time taken: 0.13 seconds, Fetched: 1824 row(s) > hive> select distinct ws_sold_date_sk from web_sales; > ---------------------------------------------------------------------------------------------- > VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING > FAILED KILLED > ---------------------------------------------------------------------------------------------- > Map 1 .......... container SUCCEEDED 1 1 0 0 > 0 0 > Reducer 2 ...... container SUCCEEDED 1 1 0 0 > 0 0 > ---------------------------------------------------------------------------------------------- > VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 2.70 s > ---------------------------------------------------------------------------------------------- > Status: DAG finished successfully in 2.70 seconds > .. > Time taken: 3.964 seconds, Fetched: 1824 row(s) > hive> select distinct ws_sold_date_sk from web_sales order by ws_sold_date_sk; > ---------------------------------------------------------------------------------------------- > VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING > FAILED KILLED > ---------------------------------------------------------------------------------------------- > Map 1 .......... container SUCCEEDED 801 801 0 0 > 0 0 > Reducer 2 ...... container SUCCEEDED 1 1 0 0 > 0 0 > Reducer 3 ...... container SUCCEEDED 1 1 0 0 > 0 0 > ---------------------------------------------------------------------------------------------- > VERTICES: 03/03 [==========================>>] 100% ELAPSED TIME: 23.05 s > ---------------------------------------------------------------------------------------------- > Status: DAG finished successfully in 23.05 seconds > ... > Time taken: 27.095 seconds, Fetched: 1824 row(s) > {noformat} > since the info is already available in metastore, it might not need to launch > these jobs. -- This message was sent by Atlassian JIRA (v6.3.4#6332)