You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Shengkai Fang (Jira)" <ji...@apache.org> on 2022/08/31 06:51:00 UTC
[jira] [Created] (FLINK-29152) Describe statement resutls is different from the Hive
Shengkai Fang created FLINK-29152:
-------------------------------------
Summary: Describe statement resutls is different from the Hive
Key: FLINK-29152
URL: https://issues.apache.org/jira/browse/FLINK-29152
Project: Flink
Issue Type: Bug
Components: Connectors / Hive
Affects Versions: 1.16.0
Reporter: Shengkai Fang
In hive, the results schema isĀ
{code:java}
+-----------+------------+----------+
| col_name | data_type | comment |
+-----------+------------+----------+
| a | int | |
| b | string | |
+-----------+------------+----------+
{code}
but our implementation is
{code:java}
0: jdbc:hive2://localhost:10000/default> describe sink;
+-------+-------+-------+-------+---------+------------+
| name | type | null | key | extras | watermark |
+-------+-------+-------+-------+---------+------------+
| a | INT | true | NULL | NULL | NULL |
+-------+-------+-------+-------+---------+------------+
{code}
BTW, it's better we can support {{DESCRIBE FORMATTED}} like hive does.
{code:java}
+-------------------------------+----------------------------------------------------+-----------------------+
| col_name | data_type | comment |
+-------------------------------+----------------------------------------------------+-----------------------+
| # col_name | data_type | comment |
| | NULL | NULL |
| a | int | |
| b | string | |
| | NULL | NULL |
| # Detailed Table Information | NULL | NULL |
| Database: | default | NULL |
| Owner: | null | NULL |
| CreateTime: | Tue Aug 30 06:54:00 UTC 2022 | NULL |
| LastAccessTime: | UNKNOWN | NULL |
| Retention: | 0 | NULL |
| Location: | hdfs://namenode:8020/user/hive/warehouse/sink | NULL |
| Table Type: | MANAGED_TABLE | NULL |
| Table Parameters: | NULL | NULL |
| | comment | |
| | numFiles | 0 |
| | totalSize | 0 |
| | transient_lastDdlTime | 1661842440 |
| | NULL | NULL |
| # Storage Information | NULL | NULL |
| SerDe Library: | org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | NULL |
| InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL |
| OutputFormat: | org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat | NULL |
| Compressed: | No | NULL |
| Num Buckets: | -1 | NULL |
| Bucket Columns: | [] | NULL |
| Sort Columns: | [] | NULL |
| Storage Desc Params: | NULL | NULL |
| | serialization.format | 1 |
+-------------------------------+----------------------------------------------------+-----------------------+
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)