[
https://issues.apache.org/jira/browse/SPARK-17660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15520189#comment-15520189
]
Apache Spark commented on SPARK-17660:
--------------------------------------
User 'gatorsmile' has created a pull request for this issue:
https://github.com/apache/spark/pull/15234
> 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
