[ 
https://issues.apache.org/jira/browse/DRILL-7472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16998166#comment-16998166
 ] 

ASF GitHub Bot commented on DRILL-7472:
---------------------------------------

asfgit commented on pull request #1925: DRILL-7472: Fix ser / de for sys and 
information_schema schemas queries
URL: https://github.com/apache/drill/pull/1925
 
 
   
 
----------------------------------------------------------------
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:
[email protected]


> Fix ser / de for sys and information_schema tables
> --------------------------------------------------
>
>                 Key: DRILL-7472
>                 URL: https://issues.apache.org/jira/browse/DRILL-7472
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.16.0
>            Reporter: Vova Vysotskyi
>            Assignee: Arina Ielchiieva
>            Priority: Major
>              Labels: ready-to-commit
>             Fix For: 1.17.0
>
>
> Run query on INFORMATION_SCHEMA:
> {code:sql}
> select * from information_schema.`tables` where TABLE_NAME='lineitem' order 
> by TABLE_NAME;
> {code}
> It will fail with the following exception:
> {noformat}
> Error: SYSTEM ERROR: InvalidDefinitionException: Cannot construct instance of 
> `org.apache.drill.exec.store.ischema.InfoSchemaFilter$ExprNode` (no Creators, 
> like default construct, exist): cannot deserialize from Object value (no 
> delegate- or property-based Creator)
>  at [Source: (String)"{
>   "pop" : "hash-partition-sender",
>   "@id" : 0,
>   "receiver-major-fragment" : 2,
>   "child" : {
>     "pop" : "InfoSchemaSubScan",
>     "@id" : 1,
>     "table" : "TABLES",
>     "filter" : {
>       "exprRoot" : {
>         "type" : "FUNCTION",
>         "function" : "equal",
>         "args" : [ {
>           "type" : "FIELD",
>           "field" : "TABLE_NAME"
>         }, {
>           "type" : "CONSTANT",
>           "value" : "lineitem"
>         } ]
>       }
>     },
>     "initialAllocation" : 1000000,
>     "maxAllocat"[truncated 681 chars]; line: 11, column: 9] (through 
> reference chain: 
> org.apache.drill.exec.physical.config.HashPartitionSender["child"]->org.apache.drill.exec.store.ischema.InfoSchemaSubScan["filter"]->org.apache.drill.exec.store.ischema.InfoSchemaFilter["exprRoot"])
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to