[jira] [Updated] (IMPALA-9183) TPC-DS query 13 - customer_address predicates not propagated to scan

2019-11-21 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-9183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-9183: -- Labels: tpc-ds (was: ) > TPC-DS query 13 - customer_address predicates not propagated to scan >

[jira] [Updated] (IMPALA-9025) An Impala query fails with error "ERROR: IllegalStateException: null"

2019-11-05 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-9025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-9025: -- Description: Synopsis: = An Impala query fails with error "ERROR: IllegalStateException:

[jira] [Updated] (IMPALA-9025) An Impala query fails with error "ERROR: IllegalStateException: null"

2019-11-05 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-9025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-9025: -- Description: Synopsis: = An Impala query fails with error "ERROR: IllegalStateException:

[jira] [Commented] (IMPALA-9025) An Impala query fails with error "ERROR: IllegalStateException: null"

2019-11-05 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-9025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16967885#comment-16967885 ] Greg Rahn commented on IMPALA-9025: --- This issue may be worked around using  {{set

[jira] [Work started] (IMPALA-8981) Support column masking in Impala

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-8981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on IMPALA-8981 started by Greg Rahn. - > Support column masking in Impala > > >

[jira] [Assigned] (IMPALA-8981) Support column masking in Impala

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-8981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn reassigned IMPALA-8981: - Assignee: Kurt Deschler (was: Greg Rahn) > Support column masking in Impala >

[jira] [Updated] (IMPALA-1728) sub-query with duplicate values used IN conditional operator should discard the duplicate values before applying the operator

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-1728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-1728: -- Labels: performance planner tpc-ds (was: TPC-DS performance planner) > sub-query with duplicate

[jira] [Updated] (IMPALA-8165) Planner does not push through predicates when there is a disjunction

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-8165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8165: -- Labels: planner sql-performance tpc-ds (was: planner tpc-ds) > Planner does not push through

[jira] [Updated] (IMPALA-7204) Add support for GROUP BY ROLLUP

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-7204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-7204: -- Labels: sql-language tpc-ds (was: sql-language) > Add support for GROUP BY ROLLUP >

[jira] [Updated] (IMPALA-891) Add support for INTERSECT and EXCEPT set operations

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-891: - Labels: sql-language tpc-ds usability (was: sql-language usability) > Add support for INTERSECT and

[jira] [Updated] (IMPALA-3531) Implement deferrable and optionally enforced PK/FK constraints

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3531: -- Labels: CBO performance ramp-up sql-language (was: CBO performance ramp-up) > Implement deferrable

[jira] [Updated] (IMPALA-7204) Add support for GROUP BY ROLLUP

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-7204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-7204: -- Labels: sql-language (was: GROUP_BY sql) > Add support for GROUP BY ROLLUP >

[jira] [Updated] (IMPALA-891) Add support for INTERSECT and EXCEPT set operations

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-891: - Issue Type: New Feature (was: Improvement) > Add support for INTERSECT and EXCEPT set operations >

[jira] [Updated] (IMPALA-8954) Support uncorrelated subqueries in the select list

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-8954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8954: -- Labels: sql-language tpc-ds (was: tpc-ds) > Support uncorrelated subqueries in the select list >

[jira] [Updated] (IMPALA-5100) add run time scalar subquery check

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-5100: -- Labels: planner ramp-up sql-language tpc-ds (was: planner ramp-up tpc-ds) > add run time scalar

[jira] [Updated] (IMPALA-1758) Impala ODBC Driver returns incorrect SQLState for "Table does not exist"

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-1758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-1758: -- Labels: jdbc odbc usability (was: jdbc odbc sql-language usability) > Impala ODBC Driver returns

[jira] [Commented] (IMPALA-1652) Fix CHAR datatype: Incorrect results with basic predicate on CHAR typed column.

2019-11-01 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-1652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964971#comment-16964971 ] Greg Rahn commented on IMPALA-1652: --- [~boristyukin] - My advice would be to "upgrade" your schemas and

[jira] [Updated] (IMPALA-3933) Time zone definitions of Hive/Spark and Impala differ for historical dates

2019-10-30 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-3933?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3933: -- Labels: timestamp (was: ) > Time zone definitions of Hive/Spark and Impala differ for historical

[jira] [Updated] (IMPALA-3933) Time zone definitions of Hive/Spark and Impala differ for historical dates

2019-10-30 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-3933?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3933: -- Labels: (was: timestamp) > Time zone definitions of Hive/Spark and Impala differ for historical

[jira] [Commented] (IMPALA-3933) Time zone definitions of Hive/Spark and Impala differ for historical dates

2019-10-30 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-3933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963654#comment-16963654 ] Greg Rahn commented on IMPALA-3933: --- [~csringhofer] / [~ajeges] - is this still an issue as of Impala

[jira] [Updated] (IMPALA-9059) Add UNPIVOT operator

2019-10-16 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-9059?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-9059: -- Labels: sql-language (was: ) > Add UNPIVOT operator > > > Key:

[jira] [Created] (IMPALA-9059) Add UNPIVOT operator

2019-10-16 Thread Greg Rahn (Jira)
Greg Rahn created IMPALA-9059: - Summary: Add UNPIVOT operator Key: IMPALA-9059 URL: https://issues.apache.org/jira/browse/IMPALA-9059 Project: IMPALA Issue Type: New Feature

[jira] [Updated] (IMPALA-2083) Add PIVOT operator

2019-10-16 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-2083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-2083: -- Description: Reference:

[jira] [Updated] (IMPALA-2083) Implement PIVOT operation in impala

2019-10-16 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-2083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-2083: -- Labels: sql-language (was: ) > Implement PIVOT operation in impala >

[jira] [Commented] (IMPALA-7759) Add Levenshtein edit distance built-in function

2019-10-14 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-7759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16951539#comment-16951539 ] Greg Rahn commented on IMPALA-7759: --- Stand-alone version here:

[jira] [Created] (IMPALA-9018) ORDER BY using an expression + column alias fails with "Could not resolve column/field"

2019-10-07 Thread Greg Rahn (Jira)
Greg Rahn created IMPALA-9018: - Summary: ORDER BY using an expression + column alias fails with "Could not resolve column/field" Key: IMPALA-9018 URL: https://issues.apache.org/jira/browse/IMPALA-9018

[jira] [Updated] (IMPALA-891) Add support for INTERSECT and EXCEPT set operations

2019-10-07 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-891: - Summary: Add support for INTERSECT and EXCEPT set operations (was: Add support for intersect and except

[jira] [Resolved] (IMPALA-3759) Add function for unix_timestamp with date format yyyyDDD

2019-10-04 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-3759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn resolved IMPALA-3759. --- Resolution: Fixed > Add function for unix_timestamp with date format DDD >

[jira] [Commented] (IMPALA-3759) Add function for unix_timestamp with date format yyyyDDD

2019-10-04 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-3759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944928#comment-16944928 ] Greg Rahn commented on IMPALA-3759: --- Converting from these input formats to DATE is supported via

[jira] [Commented] (IMPALA-2860) allow Impala to interpret "0001-01-01" and later as a date

2019-10-04 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16944923#comment-16944923 ] Greg Rahn commented on IMPALA-2860: --- Solved in IMPALA-6169 which adds DATE type. > allow Impala to

[jira] [Resolved] (IMPALA-2860) allow Impala to interpret "0001-01-01" and later as a date

2019-10-04 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn resolved IMPALA-2860. --- Resolution: Fixed > allow Impala to interpret "0001-01-01" and later as a date >

[jira] [Resolved] (IMPALA-4627) selective query optimizations

2019-10-04 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-4627?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn resolved IMPALA-4627. --- Resolution: Fixed > selective query optimizations > - > >

[jira] [Commented] (IMPALA-8954) Support subqueries in the select list

2019-09-18 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-8954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16932904#comment-16932904 ] Greg Rahn commented on IMPALA-8954: --- See also TPC-DS query 9

[jira] [Updated] (IMPALA-8954) Support subqueries in the select list

2019-09-18 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-8954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8954: -- Labels: tpc-ds (was: ) > Support subqueries in the select list >

[jira] [Resolved] (IMPALA-6057) Cache Remote Reads

2019-09-04 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-6057?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn resolved IMPALA-6057. --- Resolution: Duplicate Seems like a duplicate of IMPALA-8341 now. > Cache Remote Reads >

[jira] [Commented] (IMPALA-8891) concat_ws() null handling is non-standard

2019-08-23 Thread Greg Rahn (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-8891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16914757#comment-16914757 ] Greg Rahn commented on IMPALA-8891: --- {noformat} MariaDB [(none)]> select version(); ++

[jira] [Comment Edited] (IMPALA-8849) IllegalStateException in HashJoinNode because of missing memory limit

2019-08-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16903232#comment-16903232 ] Greg Rahn edited comment on IMPALA-8849 at 8/8/19 7:05 PM: --- IIRC it reproed

[jira] [Comment Edited] (IMPALA-8849) IllegalStateException in HashJoinNode because of missing memory limit

2019-08-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16903232#comment-16903232 ] Greg Rahn edited comment on IMPALA-8849 at 8/8/19 7:04 PM: --- IIRC it reproed

[jira] [Commented] (IMPALA-8849) IllegalStateException in HashJoinNode because of missing memory limit

2019-08-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16903232#comment-16903232 ] Greg Rahn commented on IMPALA-8849: --- IIRC it reproed with or without stats > IllegalStateException in

[jira] [Updated] (IMPALA-8849) IllegalStateException in HashJoinNode because of missing memory limit

2019-08-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8849: -- Description: [~grahn] reports the below error when running the attached TPC-DS query on uncompressed

[jira] [Commented] (IMPALA-8738) Add a column representing the type(table or view) in the show tables output

2019-08-05 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16900513#comment-16900513 ] Greg Rahn commented on IMPALA-8738: --- Hive uses {{SHOW EXTENDED TABLES}} See: 

[jira] [Updated] (IMPALA-8709) Add Damerau-Levenshtein edit distance built-in function

2019-07-04 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8709: -- Description: Algo (restricted DL / optimal string alignment)

[jira] [Commented] (IMPALA-5149) Provide query profile in JSON format

2019-07-02 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-5149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16877234#comment-16877234 ] Greg Rahn commented on IMPALA-5149: --- Examples: * Vertica: 

[jira] [Updated] (IMPALA-8709) Add Damerau-Levenshtein edit distance built-in function

2019-06-25 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8709: -- Labels: built-in-function (was: ) > Add Damerau-Levenshtein edit distance built-in function >

[jira] [Created] (IMPALA-8709) Add Damerau-Levenshtein edit distance built-in function

2019-06-25 Thread Greg Rahn (JIRA)
Greg Rahn created IMPALA-8709: - Summary: Add Damerau-Levenshtein edit distance built-in function Key: IMPALA-8709 URL: https://issues.apache.org/jira/browse/IMPALA-8709 Project: IMPALA Issue

[jira] [Updated] (IMPALA-7114) MATERIALIZE a subquery hint

2019-05-31 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-7114: -- Labels: hints optimizer (was: hints materializedviews optimizer) > MATERIALIZE a subquery hint >

[jira] [Commented] (IMPALA-8367) from_unixtime Bad date/time conversion format: u on NULL value

2019-05-22 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16846091#comment-16846091 ] Greg Rahn commented on IMPALA-8367: --- The docs should probably state what SimpleDateFormat masks/values

[jira] [Commented] (IMPALA-3381) Impala to support AM/PM format in unix_timestamp and from_unixtime

2019-05-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16835815#comment-16835815 ] Greg Rahn commented on IMPALA-3381: --- I'm good with supporting this use case in the SQL:2016 stuff

[jira] [Commented] (IMPALA-4018) Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT )

2019-04-26 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16827103#comment-16827103 ] Greg Rahn commented on IMPALA-4018: --- [~gaborkaszab], [~maze] - I'm strongly against introducing any

[jira] [Commented] (IMPALA-8108) Impala query returns TIMESTAMP values in different types

2019-03-29 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805206#comment-16805206 ] Greg Rahn commented on IMPALA-8108: --- I think there should be a way to specify a constant format for

[jira] [Updated] (IMPALA-3531) Implement deferrable and optionally enforced PK/FK constraints

2019-03-07 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3531: -- Summary: Implement deferrable and optionally enforced PK/FK constraints (was: Implement deferrable

[jira] [Commented] (IMPALA-3531) Implement deferrable and optionally enforced PK/FK constraints

2019-03-07 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16787545#comment-16787545 ] Greg Rahn commented on IMPALA-3531: --- Linking to Spark efforts on same topic SPARK-19842 > Implement

[jira] [Updated] (IMPALA-3531) Implement deferrable and optionally enforced PK/FK constraints for better CBO

2019-03-07 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3531: -- Summary: Implement deferrable and optionally enforced PK/FK constraints for better CBO (was:

[jira] [Commented] (IMPALA-3531) Implement FK/PK "rely novalidate" constraints for better CBO

2019-03-07 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16787164#comment-16787164 ] Greg Rahn commented on IMPALA-3531: --- A few comments on grammar specifics: The ANSI/ISO SQL spec

[jira] [Updated] (IMPALA-6323) Support a constant in a window specification

2019-03-07 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-6323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-6323: -- Issue Type: Bug (was: Improvement) > Support a constant in a window specification >

[jira] [Updated] (IMPALA-3760) Planner creates in-efficient join type for TPC-DS Q78

2019-03-06 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3760: -- Labels: performance tpc-ds (was: performance) > Planner creates in-efficient join type for TPC-DS

[jira] [Commented] (IMPALA-1504) Allow non-delimited-text default file formats

2019-02-24 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-1504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16776155#comment-16776155 ] Greg Rahn commented on IMPALA-1504: --- IMPALA-7645 would seem to cover this AFAIK > Allow

[jira] [Commented] (IMPALA-4018) Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT )

2019-02-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16763896#comment-16763896 ] Greg Rahn commented on IMPALA-4018: --- Our goal with this is to follow the SQL standard and make it as

[jira] [Commented] (IMPALA-5973) Provide query plan in JSON format

2019-02-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-5973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16763847#comment-16763847 ] Greg Rahn commented on IMPALA-5973: --- See also: -

[jira] [Updated] (IMPALA-8165) Planner does not push through predicates when there is a disjunction

2019-02-05 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8165: -- Description: If we take a simple query like such: {noformat} select avg(ss_quantity) from

[jira] [Updated] (IMPALA-8165) Planner does not push through predicates when there is a disjunction

2019-02-05 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8165: -- Description: If we take a simple query like such: {noformat} select avg(ss_quantity) from

[jira] [Updated] (IMPALA-8165) Planner does not push through predicates when there is a disjunction

2019-02-05 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8165: -- Labels: planner tpc-ds (was: planner) > Planner does not push through predicates when there is a

[jira] [Created] (IMPALA-8165) Planner does not push through predicates when there is a disjunction

2019-02-05 Thread Greg Rahn (JIRA)
Greg Rahn created IMPALA-8165: - Summary: Planner does not push through predicates when there is a disjunction Key: IMPALA-8165 URL: https://issues.apache.org/jira/browse/IMPALA-8165 Project: IMPALA

[jira] [Updated] (IMPALA-5022) Outer join simplification

2019-02-05 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-5022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-5022: -- Labels: planner tpc-ds (was: planner) > Outer join simplification > - > >

[jira] [Closed] (IMPALA-2200) [Cloudera][ODBC] (10000) General error: Unexpected exception has been caught.

2019-02-04 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-2200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn closed IMPALA-2200. - Resolution: Information Provided > [Cloudera][ODBC] (1) General error: Unexpected exception has

[jira] [Commented] (IMPALA-5040) User Name authentication (i.e. AuthMech=2) causes JDBC connection to get HUNG.

2019-02-04 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-5040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16760318#comment-16760318 ] Greg Rahn commented on IMPALA-5040: --- Closing issue since this JDBC driver is not part of Apache

[jira] [Closed] (IMPALA-5040) User Name authentication (i.e. AuthMech=2) causes JDBC connection to get HUNG.

2019-02-04 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-5040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn closed IMPALA-5040. - Resolution: Information Provided > User Name authentication (i.e. AuthMech=2) causes JDBC connection to

[jira] [Updated] (IMPALA-3573) Planner doesn't take into account runtime filter selectivity

2019-02-03 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3573: -- Description: Applying selective runtime filters can drastically change the cardinality of scan

[jira] [Updated] (IMPALA-3573) Planner doesn't take into account runtime filter selectivity

2019-02-03 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3573: -- Description: Applying selective runtime filters can drastically change the cardinality of scan

[jira] [Updated] (IMPALA-3573) Planner doesn't take into account runtime filter selectivity

2019-02-03 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-3573: -- Description: Applying selective runtime filters can drastically change the cardinality of scan

[jira] [Commented] (IMPALA-4018) Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT )

2019-02-01 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16758554#comment-16758554 ] Greg Rahn commented on IMPALA-4018: --- Your understanding is correct. I see the plan as such: - Since

[jira] [Comment Edited] (IMPALA-4018) Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT )

2019-01-31 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16757472#comment-16757472 ] Greg Rahn edited comment on IMPALA-4018 at 1/31/19 4:59 PM: I am strongly

[jira] [Commented] (IMPALA-4018) Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT )

2019-01-31 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16757472#comment-16757472 ] Greg Rahn commented on IMPALA-4018: --- I am strongly opposed to introducing SQL functionality that does

[jira] [Commented] (IMPALA-4018) Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT )

2019-01-30 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16756639#comment-16756639 ] Greg Rahn commented on IMPALA-4018: --- Also see: https://issues.apache.org/jira/browse/IMPALA-3381 >

[jira] [Comment Edited] (IMPALA-4018) Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT )

2019-01-30 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16756604#comment-16756604 ] Greg Rahn edited comment on IMPALA-4018 at 1/30/19 10:24 PM: - I'm not sure

[jira] [Commented] (IMPALA-4018) Add support for SQL:2016 datetime templates/patterns/masks to CAST(... AS ... FORMAT )

2019-01-30 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16756604#comment-16756604 ] Greg Rahn commented on IMPALA-4018: --- I'm not sure these can be split into two as the SQL patterns and

[jira] [Closed] (IMPALA-3784) status-benchmark is broken

2019-01-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn closed IMPALA-3784. - Resolution: Fixed Fix Version/s: Impala 2.11.0 > status-benchmark is broken >

[jira] [Commented] (IMPALA-7832) Support IF NOT EXISTS in alter table add columns

2019-01-08 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16737655#comment-16737655 ] Greg Rahn commented on IMPALA-7832: --- The ANSI SQL standard syntax for this would be: {noformat} ALTER

[jira] [Updated] (IMPALA-8054) Implicit cast fails with {const INT} BETWEEN FLOAT and INT

2019-01-07 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8054: -- Description: In the following query the literal number 10 needs to be compared to two different

[jira] [Updated] (IMPALA-8054) Implicit cast fails with {const INT} BETWEEN FLOAT and INT

2019-01-07 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8054: -- Description: In the following query the literal number 10 needs to be compared to two different

[jira] [Updated] (IMPALA-8054) Implicit cast fails with {const INT} BETWEEN FLOAT and INT

2019-01-07 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8054: -- Description: In the following query the literal number 10 needs to be compared to two different

[jira] [Created] (IMPALA-8054) Implicit cast fails with {const INT} BETWEEN FLOAT and INT

2019-01-07 Thread Greg Rahn (JIRA)
Greg Rahn created IMPALA-8054: - Summary: Implicit cast fails with {const INT} BETWEEN FLOAT and INT Key: IMPALA-8054 URL: https://issues.apache.org/jira/browse/IMPALA-8054 Project: IMPALA Issue

[jira] [Updated] (IMPALA-8028) BETWEEN predicate failures - BetweenPredicate needs to be rewritten into a CompoundPredicate

2018-12-28 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8028: -- Attachment: BetweenPredicate.sql > BETWEEN predicate failures - BetweenPredicate needs to be

[jira] [Created] (IMPALA-8029) Support DISTINCT with aggregates

2018-12-28 Thread Greg Rahn (JIRA)
Greg Rahn created IMPALA-8029: - Summary: Support DISTINCT with aggregates Key: IMPALA-8029 URL: https://issues.apache.org/jira/browse/IMPALA-8029 Project: IMPALA Issue Type: Bug

[jira] [Updated] (IMPALA-8029) Support DISTINCT with aggregates

2018-12-28 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8029: -- Labels: ansi-sql (was: ) > Support DISTINCT with aggregates > > >

[jira] [Updated] (IMPALA-8028) BETWEEN predicate failures - BetweenPredicate needs to be rewritten into a CompoundPredicate

2018-12-28 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8028: -- Labels: ansi-sql (was: ) > BETWEEN predicate failures - BetweenPredicate needs to be rewritten into

[jira] [Created] (IMPALA-8028) BETWEEN predicate failures - BetweenPredicate needs to be rewritten into a CompoundPredicate

2018-12-28 Thread Greg Rahn (JIRA)
Greg Rahn created IMPALA-8028: - Summary: BETWEEN predicate failures - BetweenPredicate needs to be rewritten into a CompoundPredicate Key: IMPALA-8028 URL: https://issues.apache.org/jira/browse/IMPALA-8028

[jira] [Updated] (IMPALA-8011) Allow filtering on virtual column for file name

2018-12-20 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-8011: -- Labels: built-in-function (was: ) > Allow filtering on virtual column for file name >

[jira] [Commented] (IMPALA-7919) Add predicates line in plan output for partition key predicates

2018-12-03 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16707600#comment-16707600 ] Greg Rahn commented on IMPALA-7919: --- I'm a believer in presenting all predicates in the node in a

[jira] [Resolved] (IMPALA-7759) Add Levenshtein edit distance built-in function

2018-12-02 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn resolved IMPALA-7759. --- Resolution: Fixed Fix Version/s: Impala 3.2.0 > Add Levenshtein edit distance built-in

[jira] [Commented] (IMPALA-7919) Add predicates line in plan output for partition key predicates

2018-12-01 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16706095#comment-16706095 ] Greg Rahn commented on IMPALA-7919: --- Had a copy mistake in the description -- the 2nd example is the

[jira] [Updated] (IMPALA-7919) Add predicates line in plan output for partition key predicates

2018-12-01 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-7919: -- Description: When there is a predicate on a partitioned table's partition key column the SCAN node

[jira] [Created] (IMPALA-7919) Add predicates line in plan output for partition key predicates

2018-12-01 Thread Greg Rahn (JIRA)
Greg Rahn created IMPALA-7919: - Summary: Add predicates line in plan output for partition key predicates Key: IMPALA-7919 URL: https://issues.apache.org/jira/browse/IMPALA-7919 Project: IMPALA

[jira] [Assigned] (IMPALA-3531) Implement FK/PK "rely novalidate" constraints for better CBO

2018-11-28 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn reassigned IMPALA-3531: - Assignee: Anurag Mantripragada (was: Greg Rahn) > Implement FK/PK "rely novalidate"

[jira] [Work started] (IMPALA-3531) Implement FK/PK "rely novalidate" constraints for better CBO

2018-11-28 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on IMPALA-3531 started by Greg Rahn. - > Implement FK/PK "rely novalidate" constraints for better CBO >

[jira] [Assigned] (IMPALA-5317) add DATE_TRUNC() function

2018-11-21 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-5317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn reassigned IMPALA-5317: - Assignee: Greg Rahn (was: sandeep akinapelli) > add DATE_TRUNC() function >

[jira] [Closed] (IMPALA-7850) INSERT using VALUES with "CAST" can cause trailing spaces.

2018-11-14 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn closed IMPALA-7850. - Resolution: Not A Bug > INSERT using VALUES with "CAST" can cause trailing spaces. >

[jira] [Work started] (IMPALA-7759) Add Levenshtein edit distance built-in function

2018-10-25 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on IMPALA-7759 started by Greg Rahn. - > Add Levenshtein edit distance built-in function >

[jira] [Updated] (IMPALA-7759) Add Levenshtein edit distance built-in function

2018-10-25 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-7759: -- Summary: Add Levenshtein edit distance built-in function (was: Add Levenshtein edit distance

[jira] [Updated] (IMPALA-7759) Add Levenshtein edit distance function

2018-10-25 Thread Greg Rahn (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Greg Rahn updated IMPALA-7759: -- Description: References: * [Netezza -

  1   2   >