ErikJansenIRefact opened a new issue #7652:
URL: https://github.com/apache/pulsar/issues/7652
#### Expected behavior
A struct property in a class should be retrieved in Presto when the topic is
queried. Preferably as a nested object or otherwise as flattened properties.
#### Actual behavior
The property isn't selected at all.
#### Steps to reproduce
Create a class with a property of type LocalDate.
Add messages to a topic with JSON schema.
Select the topic in Presto.
It is expected that the property classified as LocalDate is returned (as a
nested object).
When reading the message with Pulsar the message does contain the LocalDate
property as an object.
```
Message id: 2535:2:-1:0
Message key: 1
Message value:
{"orderNbr":1,"customerNbr":1,"orderStatus":"O","totalPrice":173665.47,"orderDate":{"year":1996,"month":"JANUARY","chronology":{"calendarType":"iso8601","id":"ISO"},"era":"CE","dayOfYear":2,"dayOfWeek":"TUESDAY","leapYear":true,"monthValue":1,"dayOfMonth":2},"orderPriority":"5-LOW","clerkNbr":"Clerk#000000951","shipPriority":0,"comment":"nstructions
sleep furiously among "}
Message publish time: 1595580635827
Message event time: 1595580635773
```
When we select in Presto this is the result:
```
select * from pulsar."public/default"."order-json-key-date" where ordernbr=1;
ordernbr | customernbr | orderstatus | totalprice | orderpriority |
clerknbr | shippriority | comment |
__partition__ | __event_time__ | __publish_time__ |
__message_id__ | __seque
----------+-------------+-------------+------------+---------------+-----------------+--------------+------------------------------------+---------------+-------------------------+-------------------------+----------------+--------
1 | 1 | O | 173665.47 | 5-LOW |
Clerk#000000951 | 0 | nstructions sleep furiously among |
-1 | 2020-07-24 10:50:35.773 | 2020-07-24 10:50:35.827 | (2535,2,0) |
(1 row)
```
The property "orderDate" is missing.
#### System configuration
**Pulsar version**: 2.6.0
----------------------------------------------------------------
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]
