Posts: 35
Registered: ‎04-07-2016

show create table X return a non-valid query

When doing a "show create table TableX", the columns are not escaped by "`" so if there is a column with a reserverd keyword ("comment" for exemple), we can't just copy past the query returned to an other database. 

Btw, I was thinking about opening a jira bug for that instead of posting it here, but I wasn't sure about the preffered way for you guys... let me know what is the prefered process for this kind on problems.




Cloudera Employee
Posts: 737
Registered: ‎03-23-2015

Re: show create table X return a non-valid query

If you think that it is a bug or improvement can be made, please feel free to create an upstream JIRA and our engineers will reply there according to the issue.