[
https://issues.apache.org/jira/browse/HIVE-24998?focusedWorklogId=580319&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-580319
]
ASF GitHub Bot logged work on HIVE-24998:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 09/Apr/21 20:51
Start Date: 09/Apr/21 20:51
Worklog Time Spent: 10m
Work Description: soumyakanti3578 opened a new pull request #2163:
URL: https://github.com/apache/hive/pull/2163
<!--
Thanks for sending a pull request! Here are some tips for you:
1. If this is your first time, please read our contributor guidelines:
https://cwiki.apache.org/confluence/display/Hive/HowToContribute
2. Ensure that you have created an issue on the Hive project JIRA:
https://issues.apache.org/jira/projects/HIVE/summary
3. Ensure you have added or run the appropriate tests for your PR:
4. If the PR is unfinished, add '[WIP]' in your PR title, e.g.,
'[WIP]HIVE-XXXXX: Your PR title ...'.
5. Be sure to keep the PR description updated to reflect all changes.
6. Please write your PR title to summarize what this PR proposes.
7. If possible, provide a concise example to reproduce the issue for a
faster review.
-->
### What changes were proposed in this pull request?
`SqlFunctionConverter.java` has been changed to make IS_DISTINCT_FROM
operator go through the CBO.
### Why are the changes needed?
Currently, insert statements are failing when IS DISTINCT FROM or IS NOT
DISTINCT FROM operators are used, which can be fixed by simply optimizing
through the CBO.
### Does this PR introduce _any_ user-facing change?
NO
### How was this patch tested?
Added tests to `is_distinct_from.q`, and validated the output.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 580319)
Remaining Estimate: 0h
Time Spent: 10m
> IS [NOT] DISTINCT FROM failing with SemanticException
> -----------------------------------------------------
>
> Key: HIVE-24998
> URL: https://issues.apache.org/jira/browse/HIVE-24998
> Project: Hive
> Issue Type: Bug
> Components: CBO
> Reporter: Soumyakanti Das
> Assignee: Soumyakanti Das
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Hive: INSERT statements failing with UDFArgumentException and
> SemanticException
> Problem Statement:
> {code:java}
> CREATE TABLE t2(c0 boolean , c1 FLOAT );
> INSERT INTO t2(c0) VALUES (NOT (0.379 IS NOT DISTINCT FROM 641));
> -- Insert failing with: Error: Error while compiling statement: FAILED:
> UDFArgumentException UDF tables only one argument (state=42000,code=40000)
> INSERT INTO t2(c0,c1) VALUES (NOT (0.379 IS NOT DISTINCT FROM 641), 0.2);
> -- Insert failing with: SemanticException 0:0 Expected 2 columns for
> insclause-0/database52@t2; select produces 1 columns. Error encountered near
> token '0.2' (state=42000,code=40000) {code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
