hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Miklos Gergely (Jira)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-22723) SHOW CREATE TABLE omits backtics, results in syntax error
Date Fri, 24 Jan 2020 12:31:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-22723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Miklos Gergely reassigned HIVE-22723:
-------------------------------------

    Assignee: Miklos Gergely

> SHOW CREATE TABLE omits backtics, results in syntax error
> ---------------------------------------------------------
>
>                 Key: HIVE-22723
>                 URL: https://issues.apache.org/jira/browse/HIVE-22723
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>         Environment: Run SHOW CREATE TABLE via AWS Athena
>            Reporter: Alex Yankelevich
>            Assignee: Miklos Gergely
>            Priority: Minor
>
> CREATE EXTERNAL TABLE `alerts1`( `_id` string COMMENT 'from deserializer', `org` string
COMMENT 'from deserializer', `collector` string COMMENT 'from deserializer', `source` string
COMMENT 'from deserializer', `entitytype` string COMMENT 'from deserializer', `entity` string
COMMENT 'from deserializer', `rule` string COMMENT 'from deserializer', `findingdescid` string
COMMENT 'from deserializer', `details` struct<parameters:struct<host_version:string,build:struct<__numberint:string>>,findingtype:string,producttype:string,entityname:string,extra:struct<version:string,build:string,updaterev:string>,entityparams:struct<deployment:array<string>,version:string,build:string>>
COMMENT 'from deserializer', `seenat` array<struct<__numberlong:string>> COMMENT
'from deserializer', `execution` array<struct<__numberlong:string>> COMMENT 'from
deserializer', `lastmodified` struct<__numberint:string> COMMENT 'from deserializer')
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' WITH SERDEPROPERTIES ( 'paths'='_id,collector,details,entity,entityType,execution,findingDescId,lastModified,org,rule,seenAt,source')
STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION 's3://redshift-poc-ay/alerts' TBLPROPERTIES ( 'CrawlerSchemaDeserializerVersion'='1.0',
'CrawlerSchemaSerializerVersion'='1.0', 'UPDATED_BY_CRAWLER'='redshift-poc-alerts-ay', 'averageRecordSize'='9619',
'classification'='json', 'compressionType'='none', 'objectCount'='1', 'recordCount'='21028',
'sizeKey'='202270843', 'transient_lastDdlTime'='1578946186', 'typeOfData'='file')    __numberint,
__numberlong columns are not generated enclosed in backticks even though they were explicitly
created with them.  Therefore, the generated DDL is syntactically incorrect. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message