[jira] [Commented] (DRILL-7380) Query of a field inside of an array of structs returns null

[ASF GitHub Bot (Jira)]

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

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

KazydubB commented on pull request #1861: DRILL-7380: Query of a field inside 
of an array of structs returns null
URL: https://github.com/apache/drill/pull/1861#discussion_r327965662
 
 

 ##########
 File path: 
logical/src/main/java/org/apache/drill/common/expression/SchemaPath.java
 ##########
 @@ -48,13 +48,20 @@
   private final NameSegment rootSegment;
 
   public SchemaPath(SchemaPath path) {
-    super(path.getPosition());
-    this.rootSegment = path.rootSegment;
+    this(path.rootSegment, path.getPosition());
   }
 
   public SchemaPath(NameSegment rootSegment) {
-    super(ExpressionPosition.UNKNOWN);
-    this.rootSegment = rootSegment;
+    this(rootSegment, ExpressionPosition.UNKNOWN);
+  }
+
+  /**
+   * @deprecated Use {@link #SchemaPath(NameSegment)}
+   * or {@link #SchemaPath(NameSegment, ExpressionPosition)} instead
+   */
+  @Deprecated
 
 Review comment:
   Why deprecate? It's rather a convenient way to create `SchemaPath`.
 
----------------------------------------------------------------
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


> Query of a field inside of an array of structs returns null
> -----------------------------------------------------------
>
>                 Key: DRILL-7380
>                 URL: https://issues.apache.org/jira/browse/DRILL-7380
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.17.0
>            Reporter: Anton Gozhiy
>            Assignee: Igor Guzenko
>            Priority: Major
>         Attachments: customer_complex.zip
>
>
> *Query:*
> {code:sql}
> select t.c_orders[0].o_orderstatus from hive.customer_complex t limit 10;
> {code}
> *Expected results (given from Hive):*
> {noformat}
> OK
> O
> F
> NULL
> O
> O
> NULL
> O
> O
> NULL
> F
> {noformat}
> *Actual results:*
> {noformat}
> null
> null
> null
> null
> null
> null
> null
> null
> null
> null
> {noformat}



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