You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (JIRA)" <ji...@apache.org> on 2016/09/25 04:52:20 UTC
[jira] [Assigned] (SPARK-17660) DESC FORMATTED for VIEW Lacks View
Definition
[ https://issues.apache.org/jira/browse/SPARK-17660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-17660:
------------------------------------
Assignee: Apache Spark
> 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
> Assignee: Apache Spark
>
> 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org