Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3273

Hive function 'concat_ws' not working from drill

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.1.0
    • Functions - Hive
    • None

    Description

      git.commit.id.abbrev=5f26b8b

      The below query from drill fails. It works from hive.

      0: jdbc:drill:schema=dfs_eea> select concat_ws(varchar_col, interval_col, '|') from hive.crosssources.fewtypes_null_hive;
      Error: SYSTEM ERROR: java.lang.RuntimeException: GenericUDF.evaluate method failed
      
      Fragment 0:0
      
      [Error Id: 2d318049-26c9-4903-a7d5-78fa61aee70c on qa-node190.qa.lab:31010] (state=,code=0)
      

      I attached the error log from drill. Let me know if you need anything.

      Attachments

        1. error.log
          25 kB
          Rahul Kumar Challapalli
        2. DRILL-3273-1.patch
          8 kB
          Venki Korukanti
        3. DRILL-3273-2.patch
          22 kB
          Venki Korukanti

        Issue Links

        Activity

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

          People

            vkorukanti Venki Korukanti
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment