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

peter zhao updated HIVE-7778:
-----------------------------

    Description: 
i run sql "set hive.exec.dynamic.partition.mode=nonstrict" with ibatis,because 
ibatis usiing xml file to hold the sql str.it has some format,so hive server 
recive the sql like this "  \t set hive.exec.dynamic.partition.mode=nonstrict  
",so 
in org.apache.hive.service.cli.operation.HiveCommandOperation.run() method, it 
deal with "\t" or any other whitespace charactors not very good.then generat 
variable key is "set hive.exec.dynamic.partition.mode", and the right key may 
be "hive.exec.dynamic.partition.mode", so my next "select by partition" sql 
throw a strict exception.

      String command = getStatement().trim();
      String[] tokens = statement.split("\\s");     //this position may be 
change to command.split("\\s"); 
      String commandArgs = command.substring(tokens[0].length()).trim();

  was:

i run sql "set hive.exec.dynamic.partition.mode=nonstrict" with ibatis,becaust 
ibatis usiing xml file to hold the sql str.it has some format,so hive server 
recive the sql like this "  \t set hive.exec.dynamic.partition.mode=nonstrict  
",so 
in org.apache.hive.service.cli.operation.HiveCommandOperation.run() method, it 
deal with "\t" not very good.then generat variable key is "set 
hive.exec.dynamic.partition.mode", and the right key may be 
"hive.exec.dynamic.partition.mode", so my next "select by partition" sql throw 
a strict exception.


> hive deal with sql witch has whitespace character
> -------------------------------------------------
>
>                 Key: HIVE-7778
>                 URL: https://issues.apache.org/jira/browse/HIVE-7778
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>    Affects Versions: 0.13.1
>            Reporter: peter zhao
>            Priority: Minor
>
> i run sql "set hive.exec.dynamic.partition.mode=nonstrict" with 
> ibatis,because ibatis usiing xml file to hold the sql str.it has some 
> format,so hive server recive the sql like this "  \t set 
> hive.exec.dynamic.partition.mode=nonstrict  ",so 
> in org.apache.hive.service.cli.operation.HiveCommandOperation.run() method, 
> it deal with "\t" or any other whitespace charactors not very good.then 
> generat variable key is "set hive.exec.dynamic.partition.mode", and the right 
> key may be "hive.exec.dynamic.partition.mode", so my next "select by 
> partition" sql throw a strict exception.
>       String command = getStatement().trim();
>       String[] tokens = statement.split("\\s");     //this position may be 
> change to command.split("\\s"); 
>       String commandArgs = command.substring(tokens[0].length()).trim();



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to