Github user rxin commented on the pull request:
https://github.com/apache/spark/pull/1265#issuecomment-47497677
This change actually exposes two other problems ...
```
-- TOK_ALLCOLREF
explain select * from (select a.key, a.* from (select * from src) a join
(select * from src1) b on (a.key = b.key)) t;
-- DOT
explain select * from (select a.key, a.`[k].*` from (select * from src) a
join (select * from src1) b on (a.key = b.key)) t;
-- EXPRESSION
explain select * from (select a.key, a.key from (select * from src) a join
(select * from src1) b on (a.key = b.key)) t;
[info] - ambiguous_col *** FAILED ***
[info] Failed to execute query using catalyst:
[info] Error: Unresolved attributes: *, tree:
[info] Project [*]
[info] Subquery t
[info] Project [key#1302,'a.[k].*]
[info] Join Inner, Some((key#1302 = key#1311))
[info] Subquery a
[info] Project [key#1302,value#1303]
[info] LowerCaseSchema
[info] InMemoryRelation [key#1302,value#1303], false,
(HiveTableScan [key#1302,value#1303], (MetastoreRelation default, src, None),
None)
[info] Subquery b
[info] Project [key#1311,value#1312]
[info] LowerCaseSchema
[info] InMemoryRelation [key#1311,value#1312], false,
(HiveTableScan [key#1311,value#1312], (MetastoreRelation default, src1, None),
None)
[info]
[info] org.apache.spark.sql.catalyst.errors.package$TreeNodeException:
Unresolved attributes: *, tree:
[info] Project [*]
[info] Subquery t
[info] Project [key#1302,'a.[k].*]
[info] Join Inner, Some((key#1302 = key#1311))
[info] Subquery a
[info] Project [key#1302,value#1303]
[info] LowerCaseSchema
[info] InMemoryRelation [key#1302,value#1303], false,
(HiveTableScan [key#1302,value#1303], (MetastoreRelation default, src, None),
None)
[info] Subquery b
[info] Project [key#1311,value#1312]
[info] LowerCaseSchema
[info] InMemoryRelation [key#1311,value#1312], false,
(HiveTableScan [key#1311,value#1312], (MetastoreRelation default, src1, None),
None)
```
```
-- HIVE-2477 Use name of original expression for name of CAST output
explain select key from (select cast(key as int) from src )t;
--backward
explain select key2 from (select cast(key as int) key2 from src )t;
[info] - alias_casted_column *** FAILED ***
[info] Failed to execute query using catalyst:
[info] Error: Unresolved attributes: 'key, tree:
[info] Project ['key]
[info] Subquery t
[info] Project [CAST(key#630, IntegerType) AS c_0#636]
[info] LowerCaseSchema
[info] InMemoryRelation [key#630,value#631], false, (HiveTableScan
[key#630,value#631], (MetastoreRelation default, src, None), None)
[info]
[info] org.apache.spark.sql.catalyst.errors.package$TreeNodeException:
Unresolved attributes: 'key, tree:
[info] Project ['key]
[info] Subquery t
[info] Project [CAST(key#630, IntegerType) AS c_0#636]
[info] LowerCaseSchema
[info] InMemoryRelation [key#630,value#631], false, (HiveTableScan
[key#630,value#631], (MetastoreRelation default, src, None), None)
[info]
```
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
