Xiao Li created SPARK-17660:
-------------------------------
Summary: DESC FORMATTED for VIEW Lacks View Definition
Key: SPARK-17660
URL: https://issues.apache.org/jira/browse/SPARK-17660
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 2.0.0, 2.1.0
Reporter: Xiao Li
Currently, DESC FORMATTED does not have a section for the view definition. We
should add it for permanent views, like what Hive does. Below is an example
with the desired view definition.
{noformat}
+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------+-------+
|col_name |data_type
|comment|
+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------+-------+
|a |int
|null |
| |
| |
|# Detailed Table Information|
| |
|Database: |default
| |
|Owner: |xiaoli
| |
|Create Time: |Sat Sep 24 21:46:19 PDT 2016
| |
|Last Access Time: |Wed Dec 31 16:00:00 PST 1969
| |
|Location: |
| |
|Table Type: |VIEW
| |
|Table Parameters: |
| |
| transient_lastDdlTime |1474778779
| |
| |
| |
|# Storage Information |
| |
|SerDe Library:
|org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
| |
|InputFormat: |org.apache.hadoop.mapred.SequenceFileInputFormat
| |
|OutputFormat:
|org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
| |
|Compressed: |No
| |
|Storage Desc Parameters: |
| |
| serialization.format |1
| |
| |
| |
|# View Information |
| |
|View Original Text: |SELECT * FROM tbl
| |
|View Expanded Text: |SELECT `gen_attr_0` AS `a` FROM (SELECT
`gen_attr_0` FROM (SELECT `a` AS `gen_attr_0` FROM `default`.`tbl`) AS
gen_subquery_0) AS tbl| |
+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------+-------+
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
