Github user dilipbiswal commented on a diff in the pull request:
https://github.com/apache/spark/pull/22868#discussion_r229063489
--- Diff: docs/sql-migration-guide-hive-compatibility.md ---
@@ -53,7 +53,20 @@ Spark SQL supports the vast majority of Hive features,
such as:
* View
* If column aliases are not specified in view definition queries, both
Spark and Hive will
generate alias names, but in different ways. In order for Spark to be
able to read views created
- by Hive, users should explicitly specify column aliases in view
definition queries.
+ by Hive, users should explicitly specify column aliases in view
definition queries. As an
+ example, Spark cannot read `v1` created as below by Hive.
+
+ ```
+ CREATE TABLE t1 (c1 INT, c2 STRING);
+ CREATE VIEW v1 AS SELECT * FROM (SELECT c1 + 1, upper(c2) FROM t1) t2;
--- End diff --
@dongjoon-hyun oh.. thanks .. because it requires an explicit correlation ?
Sorry, don't have 1.2.2 env to try out ..
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
