Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-24998

IS [NOT] DISTINCT FROM failing with SemanticException

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      Hive: INSERT statements failing with UDFArgumentException and SemanticException

      Problem Statement:

      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) 

       

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            soumyakanti.das Soumyakanti Das Assign to me
            mby Manthan B Y
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 2h
              2h

              Slack

                Issue deployment