[jira] [Updated] (HIVE-16367) Null-safe equality <=> operator is not support with CBO

2017-04-23 Thread Vineet Garg (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HIVE-16367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vineet Garg updated HIVE-16367:
---
Status: Patch Available  (was: Open)

> Null-safe equality <=> operator is not support with CBO 
> 
>
> Key: HIVE-16367
> URL: https://issues.apache.org/jira/browse/HIVE-16367
> Project: Hive
>  Issue Type: Improvement
>Reporter: Vineet Garg
>Assignee: Vineet Garg
> Attachments: HIVE-16367.1.patch
>
>
> Calcite doesn't support such equality operator so hive bails out and goes 
> through non-cbo path. This could restrict it's usage with subqueries and 
> other cbo only features.
> Since {{<=>}} is equivalent to {{is not distinct from}} (HIVE-15986) we can 
> rewrite {{<=>}} to {{is not distinct from}} and enable CBO.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Updated] (HIVE-16367) Null-safe equality <=> operator is not support with CBO

2017-04-23 Thread Vineet Garg (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HIVE-16367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vineet Garg updated HIVE-16367:
---
Attachment: HIVE-16367.1.patch

> Null-safe equality <=> operator is not support with CBO 
> 
>
> Key: HIVE-16367
> URL: https://issues.apache.org/jira/browse/HIVE-16367
> Project: Hive
>  Issue Type: Improvement
>Reporter: Vineet Garg
>Assignee: Vineet Garg
> Attachments: HIVE-16367.1.patch
>
>
> Calcite doesn't support such equality operator so hive bails out and goes 
> through non-cbo path. This could restrict it's usage with subqueries and 
> other cbo only features.
> Since {{<=>}} is equivalent to {{is not distinct from}} (HIVE-15986) we can 
> rewrite {{<=>}} to {{is not distinct from}} and enable CBO.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Updated] (HIVE-16367) Null-safe equality <=> operator is not support with CBO

2017-04-03 Thread Vineet Garg (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HIVE-16367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vineet Garg updated HIVE-16367:
---
Description: 
Calcite doesn't support such equality operator so hive bails out and goes 
through non-cbo path. This could restrict it's usage with subqueries and other 
cbo only features.

Since {{<=>}} is equivalent to {{is not distinct from}} (HIVE-15986) we can 
rewrite {{<=>}} to {{is not distinct from}} and enable CBO.

  was:
Calcite doesn't support such equality operator so hive bails out and goes 
through non-cbo path. This could restrict such operators with subqueries and 
other cbo only features.

Since {{<=>}} is equivalent to {{is not distinct from}} (HIVE-15986) we can 
rewrite {{<=>}} to {{is not distinct from}} and enable CBO.


> Null-safe equality <=> operator is not support with CBO 
> 
>
> Key: HIVE-16367
> URL: https://issues.apache.org/jira/browse/HIVE-16367
> Project: Hive
>  Issue Type: Improvement
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>
> Calcite doesn't support such equality operator so hive bails out and goes 
> through non-cbo path. This could restrict it's usage with subqueries and 
> other cbo only features.
> Since {{<=>}} is equivalent to {{is not distinct from}} (HIVE-15986) we can 
> rewrite {{<=>}} to {{is not distinct from}} and enable CBO.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)