[IMPALA-1710] Impala doesn't populate column list in "view expanded text"

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 2.1
• Component/s: Frontend
• Labels: planner
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Juan Yu
• Created: 28/Jan/15 22:22
• Updated: 06/Oct/16 23:05

Description

I have two tables, test (c1 int, c2 int), testhive(c1 int, c2 timestamp)
from impala shell
create view v_impala as select test.* from test join testhive on test.c1 = testhive.c1;
then "desc formatted v_impala", I got

| View Original Text:          | SELECT test.* FROM default.test INNER JOIN default.testhive ON test.c1 = testhive.c1 | NULL                 |
| View Expanded Text:          | SELECT test.* FROM default.test INNER JOIN default.testhive ON test.c1 = testhive.c1 | NULL   

if I create the same view "v_hive" from hive shell,
then "desc formatted v_hive" gives expanded column list.

| View Original Text:          | select test.* from test join testhive on test.c1 = testhive.c1                                                   | NULL                 |
| View Expanded Text:          | select `test`.`c1`, `test`.`c2` from `default`.`test` join `default`.`testhive` on `test`.`c1` = `testhive`.`c1` | NULL  

Issue Links

• is duplicated by: IMPALA-2741 Normalise view SQL in same way as Hive