[DRILL-1231] SQL aliases does not work properly

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.4.0
• Component/s: SQL Parser
• Assignee: Unassigned
• Reporter: Xiaomeng Huang
• Created: 31/Jul/14 00:43
• Updated: 21/Apr/15 20:00
• Resolved: 31/Jul/14 05:53

Description

git.commit.id.abbrev=0d6befc

SQL aliases does not work properly. Run the following query in SQLLine, we get

0: jdbc:drill:local=127.0.0.1:31010> select name as alias_name from sys.options limit 1;
+------------+
|    name    |
+------------+
| drill.exec.rpc.bit.server.retry.delay |
+------------+
1 row selected (0.297 seconds)

The same issue exists for hive table and dfs. View works fine though. It causes the tableau issue in DRILL-1228.

Issue Links

• contains: DRILL-1228 Connecting to Tableau live returns null values for dimensions