Apache Drill
  1. Apache Drill
  2. DRILL-822

Conversion to relational algebra failed to preserve datatypes

    Details

      Description

      Datasources: TPCH (10MB), three-way split parquet files
      git.commit.id.abbrev=2fad21d
      git.commit.id=2fad21d5a6ec43bb68fb989e48b6da180f23f73a

      0: jdbc:drill:schema=dfs.TpcHMulti> select * from region order by r_regionkey;
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "2f293a00-2cf6-4663-b961-7cde388efeb5"
      endpoint

      { address: "perfnode104.perf.lab" user_port: 31010 control_port: 31011 data_port: 31012 }

      error_type: 0
      message: "Failure while setting up Foreman. < AssertionError:[ Internal error: Conversion to relational algebra failed to preserve datatypes:
      validated type:
      RecordType(ANY *) NOT NULL
      converted type:
      RecordType(ANY *, ANY r_regionkey) NOT NULL
      rel:
      ProjectRel(*=[$0], r_regionkey=[$1])
      SortRel(sort0=[$1], dir0=[ASC])
      ProjectRel(*=[$0], r_regionkey=[$1], r_regionkey0=[$1])
      TableAccessRel(table=[[dfs, TpcHMulti, region]])
      ]"
      ]
      Error: exception while executing query (state=,code=0)

        Issue Links

          Activity

          Tony Stevenson made changes -
          Workflow no-reopen-closed, patch-avail, testing [ 12864348 ] Drill workflow [ 12934516 ]
          Jacques Nadeau made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Jacques Nadeau made changes -
          Fix Version/s 1.0.0-BETA1 [ 12324963 ]
          Jacques Nadeau made changes -
          Assignee Aman Sinha [ amansinha100 ]
          Mehant Baid made changes -
          Component/s Query Planning & Optimization [ 12322681 ]
          Component/s Functions - Drill [ 12322695 ]
          Hide
          Ramana Inukonda Nagaraj added a comment -

          Marking as duplicate.

          Show
          Ramana Inukonda Nagaraj added a comment - Marking as duplicate.
          Ramana Inukonda Nagaraj made changes -
          Field Original Value New Value
          Link This issue duplicates DRILL-586 [ DRILL-586 ]
          Zhiyong Liu created issue -

            People

            • Assignee:
              Aman Sinha
              Reporter:
              Zhiyong Liu
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development