hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "peter zhao (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-7778) hive deal with sql witch has whitespace character
Date Tue, 19 Aug 2014 06:34:18 GMT

     [ 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)

Mime
View raw message