Hi, can anyone please take a look at this and open a bug report?
I was bit by it again when trying to use the 'source' command. This time, the
semicolon is necessary, as part of the SERDEPROPERTIES of the table:
WITH SERDEPROPERTIES(
'field.delim'='\;',
'serialization.format'='\;')
Error: Error while compiling statement: FAILED: ParseException line 114:21
mismatched input '<EOF>' expecting StringLiteral near '=' in specifying
key/value property (state=42000,code=40000)
Thanks,
Bruno Kim
De: Bruno Kim Medeiros Cesar
Enviada em: quarta-feira, 1 de dezembro de 2021 15:21
Para: [email protected]
Assunto: Bug report: parse error with semicolon in string, when using 'source'
command
Hey, folks!
I see that there have been some bugs ([1], [2]) regarding semicolons within
quotes or comments, and I found another instance that I think is not handled
yet.
Here's a MWE using two files:
-- create_tab.hql
DROP TABLE IF EXISTS bkimmce_test;
CREATE TABLE bkimmce_test (
foo INT COMMENT '0 = ok; 1 = fail'
);
-- source_create_tab.hql
source create_tab.hql;
If I run "beeline -f create_tab.hql', it works OK. However, if I run 'beeline
-f source_create_tab.hql', it fails with an error:
Error: Error while compiling statement: FAILED: ParseException line 2:18
mismatched input '0' expecting StringLiteral near 'COMMENT' in column
specification (state=42000,code=40000)
Version information:
> SELECT VERSION();
2.1.1-cdh6.3.3 rec87aa011a3ef9c538b87fdb01719739f85632e2
I searched Jira for how to open an issue, but I couldn't find it. If it's
possible, I may create it.
Thanks for your attention,
Bruno Kim
[1]: [HIVE-12646] beeline and HIVE CLI do not parse ; in quote properly - ASF
JIRA (apache.org)<https://issues.apache.org/jira/browse/HIVE-12646>
[2]: [HIVE-1926] semicolon in comment causes parse error - ASF JIRA
(apache.org)<https://issues.apache.org/jira/browse/HIVE-1926>), and I found
"Esta mensagem e reservada e sua divulgacao, distribuicao, reproducao ou
qualquer forma de uso e proibida e depende de previa autorizacao desta
instituicao. O remetente utiliza o correio eletronico no exercicio do seu
trabalho ou em razao dele, eximindo esta instituicao de qualquer
responsabilidade por utilizacao indevida. Se voce recebeu esta mensagem por
engano, favor elimina-la imediatamente."
"This message is reserved and its disclosure, distribution, reproduction or any
other form of use is prohibited and shall depend upon previous proper
authorization. The sender uses the electronic mail in the exercise of his/her
work or by virtue thereof, and the institution accepts no liability for its
undue use. If you have received this e-mail by mistake, please delete it
immediately."
