[jira] [Commented] (HIVE-16768) NOT operator returns NULL from result of <=>

2017-06-05 Thread Fei Hui (JIRA) 

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

Fei Hui commented on HIVE-16768:


[~sterligovak] resolve it as duplicate. Please reopen it if it is not fixed

> NOT operator returns NULL from result of <=>
> 
>
> Key: HIVE-16768
> URL: https://issues.apache.org/jira/browse/HIVE-16768
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 2.1.1
>Reporter: Alexander Sterligov
>Assignee: Fei Hui
>
> {{SELECT "foo" <=> null;}}
> returns {{false}} as expected.
> {{SELECT NOT("foo" <=> null);}}
> returns NULL, but should return {{true}}.
> Workaround is
> {{SELECT NOT(COALESCE("foo" <=> null));}}



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

[jira] [Commented] (HIVE-16768) NOT operator returns NULL from result of <=>

2017-06-05 Thread Pengcheng Xiong (JIRA) 

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

Pengcheng Xiong commented on HIVE-16768:


[~ferhui] ,sorry my bad, it is said that it is fixed in 2.2 while 2.2 has not 
been published yet...

> NOT operator returns NULL from result of <=>
> 
>
> Key: HIVE-16768
> URL: https://issues.apache.org/jira/browse/HIVE-16768
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 2.1.1
>Reporter: Alexander Sterligov
>Assignee: Fei Hui
>
> {{SELECT "foo" <=> null;}}
> returns {{false}} as expected.
> {{SELECT NOT("foo" <=> null);}}
> returns NULL, but should return {{true}}.
> Workaround is
> {{SELECT NOT(COALESCE("foo" <=> null));}}



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

[jira] [Commented] (HIVE-16768) NOT operator returns NULL from result of <=>

2017-06-05 Thread Fei Hui (JIRA) 

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

Fei Hui commented on HIVE-16768:


[~pxiong]  HIVE-15517 is not fixed on 2.1.1, should we pick it up on branch-2.1?

> NOT operator returns NULL from result of <=>
> 
>
> Key: HIVE-16768
> URL: https://issues.apache.org/jira/browse/HIVE-16768
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 2.1.1
>Reporter: Alexander Sterligov
>Assignee: Fei Hui
>
> {{SELECT "foo" <=> null;}}
> returns {{false}} as expected.
> {{SELECT NOT("foo" <=> null);}}
> returns NULL, but should return {{true}}.
> Workaround is
> {{SELECT NOT(COALESCE("foo" <=> null));}}



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

[jira] [Commented] (HIVE-16768) NOT operator returns NULL from result of <=>

2017-06-04 Thread Pengcheng Xiong (JIRA) 

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

Pengcheng Xiong commented on HIVE-16768:


Sounds the same problem. Could u try 2.1.1 and see if it reappears? thanks.

> NOT operator returns NULL from result of <=>
> 
>
> Key: HIVE-16768
> URL: https://issues.apache.org/jira/browse/HIVE-16768
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 2.1.1
>Reporter: Alexander Sterligov
>Assignee: Fei Hui
>
> {{SELECT "foo" <=> null;}}
> returns {{false}} as expected.
> {{SELECT NOT("foo" <=> null);}}
> returns NULL, but should return {{true}}.
> Workaround is
> {{SELECT NOT(COALESCE("foo" <=> null));}}



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

[jira] [Commented] (HIVE-16768) NOT operator returns NULL from result of <=>

2017-06-04 Thread Fei Hui (JIRA) 

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

Fei Hui commented on HIVE-16768:


It is the same to HIVE-15517 [~sterligovak].
Is it right ? [~pxiong]

> NOT operator returns NULL from result of <=>
> 
>
> Key: HIVE-16768
> URL: https://issues.apache.org/jira/browse/HIVE-16768
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 2.1.1
>Reporter: Alexander Sterligov
>
> {{SELECT "foo" <=> null;}}
> returns {{false}} as expected.
> {{SELECT NOT("foo" <=> null);}}
> returns NULL, but should return {{true}}.
> Workaround is
> {{SELECT NOT(COALESCE("foo" <=> null));}}



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