[IOTDB-203] A new format for showing query results (just align data in a device)

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jialin Qiao
• Created: 07/Sep/19 01:39
• Updated: 04/Dec/19 02:45
• Resolved: 23/Oct/19 02:40

Description

When executing a SQL like "select d1.s1, d2.s1 from root.sg1", the default result set format in IoTDB is 

"time, root.sg1.d1.s1, root.sg1.d2.s1"

1 , 1, 1

2, 2, 2

However, some users want to get another format, The results could be grouped by device, then sorted by time.

"time, deviceId, s1".

1, root.sg1.d1, 1

2, root.sg1.d2, 2

 

This can be done in the client, but it would be better if we support this format in the server.

 

Issue Links

• links to: GitHub Pull Request #433