[jira] [Commented] (HIVE-20709) ASF License issue in HiveJDBCImplementor

2018-10-08 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16642040#comment-16642040 ] Ashutosh Chauhan commented on HIVE-20709: - +1 > ASF License issue in HiveJDBCImplementor >

[jira] [Commented] (HIVE-20692) Enable folding of NOT x IS (NOT) [TRUE|FALSE] expressions

2018-10-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16641325#comment-16641325 ] Ashutosh Chauhan commented on HIVE-20692: - +1 > Enable folding of NOT x IS (NOT) [TRUE|FALSE]

[jira] [Commented] (HIVE-20704) Extend HivePreFilteringRule to support other functions

2018-10-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16641107#comment-16641107 ] Ashutosh Chauhan commented on HIVE-20704: - +1 > Extend HivePreFilteringRule to support other

[jira] [Updated] (HIVE-14431) Recognize COALESCE as CASE

2018-10-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-14431: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Resolved] (HIVE-19023) Druid storage Handler still using old select query when the CBO fails

2018-10-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-19023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan resolved HIVE-19023. - Resolution: Fixed Fix Version/s: 3.1.0 4.0.0 > Druid storage

[jira] [Commented] (HIVE-20698) Better error instead of NPE when timestamp is null for any row when ingesting to druid

2018-10-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16640473#comment-16640473 ] Ashutosh Chauhan commented on HIVE-20698: - +1 pending tests > Better error instead of NPE when

[jira] [Commented] (HIVE-20700) Add config to disable rollup for druid

2018-10-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16640469#comment-16640469 ] Ashutosh Chauhan commented on HIVE-20700: - +1 pending tests > Add config to disable rollup for

[jira] [Commented] (HIVE-20652) JdbcStorageHandler push join of two different datasource to jdbc driver

2018-10-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16640390#comment-16640390 ] Ashutosh Chauhan commented on HIVE-20652: - +1 > JdbcStorageHandler push join of two different

[jira] [Commented] (HIVE-20687) Cancel Running Druid Query when a hive query is cancelled.

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639083#comment-16639083 ] Ashutosh Chauhan commented on HIVE-20687: - Sounds like a good approach. One thing I am not sure

[jira] [Commented] (HIVE-18785) Make JSON SerDe First-Class SerDe

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639125#comment-16639125 ] Ashutosh Chauhan commented on HIVE-18785: - HIVE-20375 is a functional regression on master

[jira] [Commented] (HIVE-20660) Group by statistics estimation could be improved by bounding the total number of rows to source table

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639096#comment-16639096 ] Ashutosh Chauhan commented on HIVE-20660: - [~vgarg] Can you update the golden file and create RB

[jira] [Commented] (HIVE-20686) Sync QueryIDs across hive and druid

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639085#comment-16639085 ] Ashutosh Chauhan commented on HIVE-20686: - Need to update Druid tests, others look like flaky

[jira] [Commented] (HIVE-20684) Analyze table compute stats fails for tables containing timestamp with local time zone column

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639081#comment-16639081 ] Ashutosh Chauhan commented on HIVE-20684: - +1 If failures are not related, can you reattach patch

[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639078#comment-16639078 ] Ashutosh Chauhan commented on HIVE-20590: - +1 pending tests. > Allow merge statement to have

[jira] [Commented] (HIVE-14431) Recognize COALESCE as CASE

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639065#comment-16639065 ] Ashutosh Chauhan commented on HIVE-14431: - +1 pending tests > Recognize COALESCE as CASE >

[jira] [Commented] (HIVE-14431) Recognize COALESCE as CASE

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16638810#comment-16638810 ] Ashutosh Chauhan commented on HIVE-14431: - HIVE-20563 is in. [~jcamachorodriguez] Can you

[jira] [Updated] (HIVE-20563) Vectorization: CASE WHEN expression fails when THEN/ELSE type and result type are different

2018-10-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20563: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20686) Sync QueryIDs across hive and druid

2018-10-03 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16637548#comment-16637548 ] Ashutosh Chauhan commented on HIVE-20686: - +1 pending tests. > Sync QueryIDs across hive and

[jira] [Commented] (HIVE-20536) Add Surrogate Keys function to Hive

2018-10-02 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16636480#comment-16636480 ] Ashutosh Chauhan commented on HIVE-20536: - [~mgergely] [~vgarg] Actually merge statement already

[jira] [Commented] (HIVE-20563) Vectorization: CASE WHEN expression fails when THEN/ELSE type and result type are different

2018-10-02 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16636374#comment-16636374 ] Ashutosh Chauhan commented on HIVE-20563: - [~gopalv] [~teddy.choi] Can you please review? >

[jira] [Updated] (HIVE-20609) Create SSD cache dir if it doesnt exist already

2018-10-02 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20609: Resolution: Fixed Fix Version/s: (was: 3.0.1) 4.0.0

[jira] [Commented] (HIVE-18945) Support "analyze table T"

2018-10-02 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16636227#comment-16636227 ] Ashutosh Chauhan commented on HIVE-18945: - I beg to differ. {{analyze table T}} syntax will cause

[jira] [Commented] (HIVE-20636) Improve number of null values estimation after outer join

2018-09-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16633561#comment-16633561 ] Ashutosh Chauhan commented on HIVE-20636: - +1 > Improve number of null values estimation after

[jira] [Updated] (HIVE-20637) Allow any udfs with 0 arguments or with constant arguments as part of default clause

2018-09-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20637: Resolution: Fixed Fix Version/s: (was: 3.0.1) 4.0.0

[jira] [Commented] (HIVE-20637) Allow any udfs with 0 arguments or with constant arguments as part of default clause

2018-09-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16633541#comment-16633541 ] Ashutosh Chauhan commented on HIVE-20637: - +1 > Allow any udfs with 0 arguments or with constant

[jira] [Updated] (HIVE-20626) Log more details when druid metastore transaction fails in callback

2018-09-24 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20626: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20626) Log more details when druid metastore transaction fails in callback

2018-09-24 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16625921#comment-16625921 ] Ashutosh Chauhan commented on HIVE-20626: - +1 > Log more details when druid metastore

[jira] [Commented] (HIVE-20625) Regex patterns not working in SHOW MATERIALIZED VIEWS ''

2018-09-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16625222#comment-16625222 ] Ashutosh Chauhan commented on HIVE-20625: - +1 pending tests > Regex patterns not working in SHOW

[jira] [Commented] (HIVE-20612) Create new join multi-key correlation flag for CBO

2018-09-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16625216#comment-16625216 ] Ashutosh Chauhan commented on HIVE-20612: - +1 > Create new join multi-key correlation flag for

[jira] [Commented] (HIVE-20385) Date: date + int fails to add days

2018-09-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16624993#comment-16624993 ] Ashutosh Chauhan commented on HIVE-20385: - +1 > Date: date + int fails to add days >

[jira] [Commented] (HIVE-18628) Make tez dag status check interval configurable

2018-09-22 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16624976#comment-16624976 ] Ashutosh Chauhan commented on HIVE-18628: - [~prasanth_j] This partly undid HIVE-16635 Was that

[jira] [Commented] (HIVE-20618) During join selection BucketMapJoin might be choosen for non bucketed tables

2018-09-22 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16624969#comment-16624969 ] Ashutosh Chauhan commented on HIVE-20618: - [~djaiswal] Can you also please review? > During join

[jira] [Commented] (HIVE-20618) During join selection BucketMapJoin might be choosen for non bucketed tables

2018-09-22 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16624759#comment-16624759 ] Ashutosh Chauhan commented on HIVE-20618: - +1 > During join selection BucketMapJoin might be

[jira] [Commented] (HIVE-20598) Fix typos in HiveAlgorithmsUtil calculations

2018-09-20 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16622252#comment-16622252 ] Ashutosh Chauhan commented on HIVE-20598: - +1 > Fix typos in HiveAlgorithmsUtil calculations >

[jira] [Updated] (HIVE-20536) Add Surrogate Keys function to Hive

2018-09-19 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20536: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20536) Add Surrogate Keys function to Hive

2018-09-19 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16620716#comment-16620716 ] Ashutosh Chauhan commented on HIVE-20536: - -ve values for surrogate keys are ok, since surrogate

[jira] [Updated] (HIVE-20349) Implement Retry Logic in HiveDruidSplit for Scan Queries

2018-09-19 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20349: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20536) Add Surrogate Keys function to Hive

2018-09-18 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16619931#comment-16619931 ] Ashutosh Chauhan commented on HIVE-20536: - OK, can you please create a jira for it, so that we

[jira] [Commented] (HIVE-20536) Add Surrogate Keys function to Hive

2018-09-18 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16619819#comment-16619819 ] Ashutosh Chauhan commented on HIVE-20536: - [~vgarg] Don't we support default clause for merge? >

[jira] [Commented] (HIVE-20385) Date: date + int fails to add days

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16618357#comment-16618357 ] Ashutosh Chauhan commented on HIVE-20385: - [~bpusztahazi] Return type for date + int (or date -

[jira] [Commented] (HIVE-20563) Vectorization: CASE WHEN expression fails when THEN/ELSE type and result type are different

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16618333#comment-16618333 ] Ashutosh Chauhan commented on HIVE-20563: - What will it take to vectorize these case expressions

[jira] [Updated] (HIVE-20560) Set hive.llap.memory.oversubscription.max.executors.per.query to be 1/3rd of num of executors per node

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20560: Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master.

[jira] [Updated] (HIVE-20560) Set hive.llap.memory.oversubscription.max.executors.per.query to be 1/3rd of num of executors per node

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20560: Summary: Set hive.llap.memory.oversubscription.max.executors.per.query to be 1/3rd of num

[jira] [Commented] (HIVE-20536) Add Surrogate Keys function to Hive

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16618145#comment-16618145 ] Ashutosh Chauhan commented on HIVE-20536: - Can you create a review board request on

[jira] [Commented] (HIVE-20558) Change default of hive.hashtable.key.count.adjustment to 0.99

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16618143#comment-16618143 ] Ashutosh Chauhan commented on HIVE-20558: - Default currently is 2. This affects initial size of

[jira] [Commented] (HIVE-20560) Set hive.llap.memory.oversubscription.max.executors.per.query to be 1/3rd of num of llap daemons

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16617921#comment-16617921 ] Ashutosh Chauhan commented on HIVE-20560: - +1 > Set

[jira] [Commented] (HIVE-20560) Set hive.llap.memory.oversubscription.max.executors.per.query to be 1/3rd of num of llap daemons

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16617689#comment-16617689 ] Ashutosh Chauhan commented on HIVE-20560: - you may also add reset

[jira] [Updated] (HIVE-20571) Change default value of hive.tez.dag.status.check.interval

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20571: Attachment: HIVE-20571.2.patch > Change default value of

[jira] [Updated] (HIVE-20571) Change default value of hive.tez.dag.status.check.interval

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20571: Status: Patch Available (was: Open) > Change default value of

[jira] [Updated] (HIVE-20571) Change default value of hive.tez.dag.status.check.interval

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20571: Status: Open (was: Patch Available) > Change default value of

[jira] [Commented] (HIVE-20560) Set hive.llap.memory.oversubscription.max.executors.per.query to be 1/3rd of num of llap daemons

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16617132#comment-16617132 ] Ashutosh Chauhan commented on HIVE-20560: - Can't access test report anymore. But I presume its

[jira] [Updated] (HIVE-20572) Change default value of hive.tez.llap.min.reducer.per.executor

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20572: Status: Patch Available (was: Open) > Change default value of

[jira] [Updated] (HIVE-20572) Change default value of hive.tez.llap.min.reducer.per.executor

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20572: Attachment: HIVE-20572.patch > Change default value of

[jira] [Assigned] (HIVE-20572) Change default value of hive.tez.llap.min.reducer.per.executor

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan reassigned HIVE-20572: --- > Change default value of hive.tez.llap.min.reducer.per.executor >

[jira] [Updated] (HIVE-20571) Change default value of hive.tez.dag.status.check.interval

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20571: Status: Patch Available (was: Open) > Change default value of

[jira] [Updated] (HIVE-20571) Change default value of hive.tez.dag.status.check.interval

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20571: Attachment: HIVE-20571.patch > Change default value of hive.tez.dag.status.check.interval

[jira] [Assigned] (HIVE-20571) Change default value of hive.tez.dag.status.check.interval

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan reassigned HIVE-20571: --- > Change default value of hive.tez.dag.status.check.interval >

[jira] [Updated] (HIVE-20558) Change default of hive.hashtable.key.count.adjustment to 0.99

2018-09-17 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20558: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20559) Turn on hive.transpose.aggr.join by default

2018-09-16 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16616959#comment-16616959 ] Ashutosh Chauhan commented on HIVE-20559: - Note that rule does cost based decision. So, these

[jira] [Updated] (HIVE-20325) FlakyTest: TestMiniDruidCliDriver

2018-09-15 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20325: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20325) FlakyTest: TestMiniDruidCliDriver

2018-09-15 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16616504#comment-16616504 ] Ashutosh Chauhan commented on HIVE-20325: - +1 > FlakyTest: TestMiniDruidCliDriver >

[jira] [Updated] (HIVE-18583) Enable DateRangeRules

2018-09-14 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-18583: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20537) Multi-column joins estimates with uncorrelated columns different in CBO and Hive

2018-09-14 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16615051#comment-16615051 ] Ashutosh Chauhan commented on HIVE-20537: - +1 > Multi-column joins estimates with uncorrelated

[jira] [Updated] (HIVE-20558) Change default of hive.hashtable.key.count.adjustment to 0.99

2018-09-13 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20558: Attachment: HIVE-20558.patch > Change default of hive.hashtable.key.count.adjustment to

[jira] [Updated] (HIVE-20558) Change default of hive.hashtable.key.count.adjustment to 0.99

2018-09-13 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20558: Status: Patch Available (was: Open) > Change default of

[jira] [Assigned] (HIVE-20558) Change default of hive.hashtable.key.count.adjustment to 0.99

2018-09-13 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan reassigned HIVE-20558: --- > Change default of hive.hashtable.key.count.adjustment to 0.99 >

[jira] [Commented] (HIVE-20536) Add Surrogate Keys function to Hive

2018-09-12 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16612695#comment-16612695 ] Ashutosh Chauhan commented on HIVE-20536: - adding tableDesc to GenericUDF is not a good idea. Its

[jira] [Updated] (HIVE-20539) Remove dependency on com.metamx.java-util

2018-09-12 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20539: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20349) Implement Retry Logic in HiveDruidSplit for Scan Queries

2018-09-12 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16612269#comment-16612269 ] Ashutosh Chauhan commented on HIVE-20349: - [~nishantbangarwa] Can you rebase and reupload the

[jira] [Commented] (HIVE-20539) Remove dependency on com.metamx.java-util

2018-09-11 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16611262#comment-16611262 ] Ashutosh Chauhan commented on HIVE-20539: - +1 pending tests > Remove dependency on

[jira] [Commented] (HIVE-20520) length(CHAR) doesn't consider trailing space

2018-09-10 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20520?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16609795#comment-16609795 ] Ashutosh Chauhan commented on HIVE-20520: - +1 cc: [~jdere] : area expert! > length(CHAR)

[jira] [Commented] (HIVE-20471) issues getting the default database path

2018-09-10 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16609779#comment-16609779 ] Ashutosh Chauhan commented on HIVE-20471: - +1 > issues getting the default database path >

[jira] [Commented] (HIVE-20503) Use datastructure aware estimations during mapjoin selection

2018-09-10 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16609533#comment-16609533 ] Ashutosh Chauhan commented on HIVE-20503: - I see. +1 > Use datastructure aware estimations

[jira] [Commented] (HIVE-20522) HiveFilterSetOpTransposeRule may throw assertion error due to nullability of fields

2018-09-08 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16608146#comment-16608146 ] Ashutosh Chauhan commented on HIVE-20522: - +1 > HiveFilterSetOpTransposeRule may throw assertion

[jira] [Commented] (HIVE-20503) Use datastructure aware estimations during mapjoin selection

2018-09-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16607786#comment-16607786 ] Ashutosh Chauhan commented on HIVE-20503: - private boolean useFastHashTable; Do we still need

[jira] [Updated] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions

2018-09-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20080: Resolution: Fixed Fix Version/s: 2.4.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20518) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions

2018-09-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16607441#comment-16607441 ] Ashutosh Chauhan commented on HIVE-20518: - HIVE-20080 provided fix for same issue for branch-2.

[jira] [Assigned] (HIVE-20518) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions

2018-09-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan reassigned HIVE-20518: --- > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than

[jira] [Updated] (HIVE-20499) GetTablesOperation pull all the tables meta irrespective of auth.

2018-09-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20499: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions

2018-09-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16607403#comment-16607403 ] Ashutosh Chauhan commented on HIVE-20080: - +1 [~Rajkumar Singh] Can you please create a jira for

[jira] [Commented] (HIVE-20499) GetTablesOperation pull all the tables meta irrespective of auth.

2018-09-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16607399#comment-16607399 ] Ashutosh Chauhan commented on HIVE-20499: - +1 > GetTablesOperation pull all the tables meta

[jira] [Commented] (HIVE-20503) Use datastructure aware estimations during mapjoin selection

2018-09-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16606730#comment-16606730 ] Ashutosh Chauhan commented on HIVE-20503: - Actually longer term we will abandon optimized

[jira] [Reopened] (HIVE-20480) Implement column stats annotation rules for the UDTFOperator: Follow up for HIVE-20262

2018-09-06 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan reopened HIVE-20480: - Reverted. > Implement column stats annotation rules for the UDTFOperator: Follow up for >

[jira] [Commented] (HIVE-20504) Give simple MJ bigger priority than bucketized ones

2018-09-06 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16606598#comment-16606598 ] Ashutosh Chauhan commented on HIVE-20504: - [~gopalv] What do you think? Currently we try SMBJ

[jira] [Commented] (HIVE-20503) Use datastructure aware estimations during mapjoin selection

2018-09-06 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16606596#comment-16606596 ] Ashutosh Chauhan commented on HIVE-20503: - [~kgyrtkirk] Can you please create a RB for it? > Use

[jira] [Commented] (HIVE-20202) Add profiler endpoint to HS2 and LLAP

2018-09-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16605176#comment-16605176 ] Ashutosh Chauhan commented on HIVE-20202: - +1 > Add profiler endpoint to HS2 and LLAP >

[jira] [Updated] (HIVE-20480) Implement column stats annotation rules for the UDTFOperator: Follow up for HIVE-20262

2018-09-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20480: Fix Version/s: 4.0.0 > Implement column stats annotation rules for the UDTFOperator:

[jira] [Commented] (HIVE-20480) Implement column stats annotation rules for the UDTFOperator: Follow up for HIVE-20262

2018-09-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16605156#comment-16605156 ] Ashutosh Chauhan commented on HIVE-20480: - +1 > Implement column stats annotation rules for the

[jira] [Commented] (HIVE-20296) Improve HivePointLookupOptimizerRule to be able to extract from more sophisticated contexts

2018-09-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16605148#comment-16605148 ] Ashutosh Chauhan commented on HIVE-20296: - +1 Some minor comments on RB which you may do before

[jira] [Commented] (HIVE-20501) Vectorization: Closed range fast-path for Fast Long hashset

2018-09-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16605137#comment-16605137 ] Ashutosh Chauhan commented on HIVE-20501: - [~gopalv] Can you describe what this patch is trying

[jira] [Commented] (HIVE-20491) Fix mapjoin size estimations for Fast implementation

2018-09-05 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16604008#comment-16604008 ] Ashutosh Chauhan commented on HIVE-20491: - Ok. As it currently stands we always estimate assuming

[jira] [Commented] (HIVE-20432) Rewrite BETWEEN to IN for integer types for stats estimation

2018-09-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16603938#comment-16603938 ] Ashutosh Chauhan commented on HIVE-20432: - 1. Instead of if (leftValue instanceof Integer) {..}

[jira] [Commented] (HIVE-20491) Fix mapjoin size estimations for Fast implementation

2018-09-04 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16603246#comment-16603246 ] Ashutosh Chauhan commented on HIVE-20491: - [~kgyrtkirk] Selection of kind of hashtable is done by

[jira] [Updated] (HIVE-20449) DruidMiniTests - Move creation of druid table from allTypesOrc to test setup phase

2018-08-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20449: Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch

[jira] [Updated] (HIVE-20467) Allow IF NOT EXISTS/IF EXISTS in Resource plan creation/drop

2018-08-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-20467: Resolution: Fixed Fix Version/s: (was: 3.0.1) 4.0.0

[jira] [Commented] (HIVE-20449) DruidMiniTests - Move creation of druid table from allTypesOrc to test setup phase

2018-08-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16593983#comment-16593983 ] Ashutosh Chauhan commented on HIVE-20449: - I see. Thanks for explaining. +1 pending tests >

[jira] [Commented] (HIVE-20449) DruidMiniTests - Move creation of druid table from allTypesOrc to test setup phase

2018-08-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16593957#comment-16593957 ] Ashutosh Chauhan commented on HIVE-20449: - Who executes

[jira] [Commented] (HIVE-18583) Enable DateRangeRules

2018-08-24 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16592088#comment-16592088 ] Ashutosh Chauhan commented on HIVE-18583: - +1 > Enable DateRangeRules > --

[jira] [Commented] (HIVE-20439) Use the inflated memory limit during join selection for llap

2018-08-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16591161#comment-16591161 ] Ashutosh Chauhan commented on HIVE-20439: - +1 > Use the inflated memory limit during join

[jira] [Commented] (HIVE-20349) Implement Retry Logic in HiveDruidSplit for Scan Queries

2018-08-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16589795#comment-16589795 ] Ashutosh Chauhan commented on HIVE-20349: - +1 > Implement Retry Logic in HiveDruidSplit for Scan

<    5   6   7   8   9   10   11   12   13   14   >