You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/01/07 22:54:39 UTC
svn commit: r897026 [1/4] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Author: namit
Date: Thu Jan 7 21:54:33 2010
New Revision: 897026
URL: http://svn.apache.org/viewvc?rev=897026&view=rev
Log:
HIVE-1031 describe function array throws ParseException
(Carl Steinbach via namit)
Added:
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_add.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_avg.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bigint.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_and.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_not.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_or.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_xor.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_boolean.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceil.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceiling.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_count.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_add.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_sub.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_datediff.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_day.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_dayofmonth.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_div.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divide.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_double.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_equal.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_exp.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_explode.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_float.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_floor.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_from_unixtime.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_index.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_int.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnotnull.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnull.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lcase.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ln.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log10.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log2.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ltrim.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_max.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_min.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_minute.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_modulo.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_month.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_not.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_notequal.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_or.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_positive.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_pow.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_power.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rand.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_extract.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_replace.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rlike.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rpad.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rtrim.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_second.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_smallint.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sqrt.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_std.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_pop.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_stddev_samp.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_string.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_substring.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_subtract.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_sum.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_tinyint.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_to_date.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_trim.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ucase.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_upper.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_pop.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_var_samp.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_variance.q
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_add.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_avg.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bigint.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_and.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_not.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_or.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_bitwise_xor.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_boolean.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceil.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ceiling.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_count.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_add.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_date_sub.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_datediff.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_day.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_dayofmonth.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_div.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divide.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_double.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_equal.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_exp.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_float.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_floor.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_from_unixtime.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthan.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_index.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_int.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnotnull.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lcase.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthan.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ln.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log10.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log2.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ltrim.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_max.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_min.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_minute.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_modulo.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_month.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_notequal.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_or.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_pow.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_power.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rand.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_extract.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp_replace.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rlike.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rpad.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_rtrim.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_second.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_smallint.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sqrt.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_std.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_pop.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_stddev_samp.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_string.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substring.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_subtract.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sum.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_tinyint.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_to_date.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_trim.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ucase.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_upper.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_pop.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_var_samp.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_variance.q.out
Modified:
hadoop/hive/trunk/CHANGES.txt
hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java
hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_function.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_avg.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_count.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_max.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_min.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_std.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_stddev_samp.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_sum.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_var_samp.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_variance.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_array.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_case.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divider.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour_minute_second.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_json.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad_rpad.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_map.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_negative.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_when.q
hadoop/hive/trunk/ql/src/test/queries/clientpositive/udtf_explode.q
hadoop/hive/trunk/ql/src/test/results/clientpositive/describe_function.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/show_functions.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_avg.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_count.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_max.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_min.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_std.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_stddev_samp.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_sum.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_var_samp.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_variance.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_array.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_regexp.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out
hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out
Modified: hadoop/hive/trunk/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/CHANGES.txt?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/CHANGES.txt (original)
+++ hadoop/hive/trunk/CHANGES.txt Thu Jan 7 21:54:33 2010
@@ -412,7 +412,10 @@
HIVE-1030 mapjoin should throw an error if the input is too large
(Ning Zhang via namit)
- HIVE-996 describe function" throws NPE when when called on UDTF or UDAF
+ HIVE-996 describe function throws NPE when when called on UDTF or UDAF
+ (Carl Steinbach via namit)
+
+ HIVE-1031 describe function array throws ParseException
(Carl Steinbach via namit)
Release 0.4.0 - Unreleased
Modified: hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java (original)
+++ hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java Thu Jan 7 21:54:33 2010
@@ -82,7 +82,9 @@
import org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe;
import org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe;
import org.apache.hadoop.hive.shims.ShimLoader;
-import org.apache.hadoop.util.StringUtils;
+
+import static org.apache.hadoop.util.StringUtils.stringifyException;
+import static org.apache.commons.lang.StringUtils.join;
/**
* DDLTask implementation
@@ -174,14 +176,14 @@
} catch (InvalidTableException e) {
console.printError("Table " + e.getTableName() + " does not exist");
- LOG.debug(StringUtils.stringifyException(e));
+ LOG.debug(stringifyException(e));
return 1;
} catch (HiveException e) {
- console.printError("FAILED: Error in metadata: " + e.getMessage(), "\n" + StringUtils.stringifyException(e));
- LOG.debug(StringUtils.stringifyException(e));
+ console.printError("FAILED: Error in metadata: " + e.getMessage(), "\n" + stringifyException(e));
+ LOG.debug(stringifyException(e));
return 1;
} catch (Exception e) {
- console.printError("Failed with exception " + e.getMessage(), "\n" + StringUtils.stringifyException(e));
+ console.printError("Failed with exception " + e.getMessage(), "\n" + stringifyException(e));
return (1);
}
assert false;
@@ -363,10 +365,10 @@
}
((FSDataOutputStream)outStream).close();
} catch (FileNotFoundException e) {
- LOG.info("show partitions: " + StringUtils.stringifyException(e));
+ LOG.info("show partitions: " + stringifyException(e));
throw new HiveException(e.toString());
} catch (IOException e) {
- LOG.info("show partitions: " + StringUtils.stringifyException(e));
+ LOG.info("show partitions: " + stringifyException(e));
throw new HiveException(e.toString());
} catch (Exception e) {
throw new HiveException(e.toString());
@@ -408,10 +410,10 @@
}
((FSDataOutputStream)outStream).close();
} catch (FileNotFoundException e) {
- LOG.warn("show table: " + StringUtils.stringifyException(e));
+ LOG.warn("show table: " + stringifyException(e));
return 1;
} catch (IOException e) {
- LOG.warn("show table: " + StringUtils.stringifyException(e));
+ LOG.warn("show table: " + stringifyException(e));
return 1;
} catch (Exception e) {
throw new HiveException(e.toString());
@@ -451,10 +453,10 @@
}
((FSDataOutputStream)outStream).close();
} catch (FileNotFoundException e) {
- LOG.warn("show function: " + StringUtils.stringifyException(e));
+ LOG.warn("show function: " + stringifyException(e));
return 1;
} catch (IOException e) {
- LOG.warn("show function: " + StringUtils.stringifyException(e));
+ LOG.warn("show function: " + stringifyException(e));
return 1;
} catch (Exception e) {
throw new HiveException(e.toString());
@@ -489,14 +491,20 @@
}
if (desc != null) {
outStream.writeBytes(desc.value().replace("_FUNC_", funcName));
- if(descFunc.isExtended() && desc.extended().length() > 0) {
- outStream.writeBytes("\n"+desc.extended().replace("_FUNC_", funcName));
+ if(descFunc.isExtended()) {
+ Set<String> synonyms = FunctionRegistry.getFunctionSynonyms(funcName);
+ if (synonyms.size() > 0) {
+ outStream.writeBytes("\nSynonyms: " + join(synonyms, ", "));
+ }
+ if (desc.extended().length() > 0) {
+ outStream.writeBytes("\n"+desc.extended().replace("_FUNC_", funcName));
+ }
}
} else {
if (funcClass != null) {
- outStream.writeBytes("There is no documentation for function " + funcName);
+ outStream.writeBytes("There is no documentation for function '" + funcName + "'");
} else {
- outStream.writeBytes("Function " + funcName + " does not exist.");
+ outStream.writeBytes("Function '" + funcName + "' does not exist.");
}
}
@@ -504,10 +512,10 @@
((FSDataOutputStream)outStream).close();
} catch (FileNotFoundException e) {
- LOG.warn("describe function: " + StringUtils.stringifyException(e));
+ LOG.warn("describe function: " + stringifyException(e));
return 1;
} catch (IOException e) {
- LOG.warn("describe function: " + StringUtils.stringifyException(e));
+ LOG.warn("describe function: " + stringifyException(e));
return 1;
} catch (Exception e) {
throw new HiveException(e.toString());
@@ -619,10 +627,10 @@
}
((FSDataOutputStream) outStream).close();
} catch (FileNotFoundException e) {
- LOG.info("show table status: " + StringUtils.stringifyException(e));
+ LOG.info("show table status: " + stringifyException(e));
return 1;
} catch (IOException e) {
- LOG.info("show table status: " + StringUtils.stringifyException(e));
+ LOG.info("show table status: " + stringifyException(e));
return 1;
} catch (Exception e) {
throw new HiveException(e.toString());
@@ -670,10 +678,10 @@
tbl = part.getTable();
}
} catch (FileNotFoundException e) {
- LOG.info("describe table: " + StringUtils.stringifyException(e));
+ LOG.info("describe table: " + stringifyException(e));
return 1;
} catch (IOException e) {
- LOG.info("describe table: " + StringUtils.stringifyException(e));
+ LOG.info("describe table: " + stringifyException(e));
return 1;
}
@@ -746,10 +754,10 @@
((FSDataOutputStream) outStream).close();
} catch (FileNotFoundException e) {
- LOG.info("describe table: " + StringUtils.stringifyException(e));
+ LOG.info("describe table: " + stringifyException(e));
return 1;
} catch (IOException e) {
- LOG.info("describe table: " + StringUtils.stringifyException(e));
+ LOG.info("describe table: " + stringifyException(e));
return 1;
} catch (Exception e) {
throw new HiveException(e.toString());
@@ -1026,7 +1034,7 @@
try {
tbl.setProperty("last_modified_by", conf.getUser());
} catch (IOException e) {
- console.printError("Unable to get current user: " + e.getMessage(), StringUtils.stringifyException(e));
+ console.printError("Unable to get current user: " + e.getMessage(), stringifyException(e));
return 1;
}
tbl.setProperty("last_modified_time", Long.toString(System
@@ -1035,7 +1043,7 @@
try {
tbl.checkValidity();
} catch (HiveException e) {
- console.printError("Invalid table columns : " + e.getMessage(), StringUtils.stringifyException(e));
+ console.printError("Invalid table columns : " + e.getMessage(), stringifyException(e));
return 1;
}
@@ -1043,7 +1051,7 @@
db.alterTable(alterTbl.getOldName(), tbl);
} catch (InvalidOperationException e) {
console.printError("Invalid alter operation: " + e.getMessage());
- LOG.info("alter table: " + StringUtils.stringifyException(e));
+ LOG.info("alter table: " + stringifyException(e));
return 1;
} catch (HiveException e) {
return 1;
@@ -1252,7 +1260,7 @@
try {
tbl.setOwner(conf.getUser());
} catch (IOException e) {
- console.printError("Unable to get current user: " + e.getMessage(), StringUtils.stringifyException(e));
+ console.printError("Unable to get current user: " + e.getMessage(), stringifyException(e));
return 1;
}
// set create time
Modified: hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java (original)
+++ hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java Thu Jan 7 21:54:33 2010
@@ -25,6 +25,7 @@
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
+import java.util.HashSet;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
@@ -37,9 +38,124 @@
import org.apache.hadoop.hive.ql.parse.SemanticException;
import org.apache.hadoop.hive.ql.plan.exprNodeDesc;
import org.apache.hadoop.hive.ql.plan.exprNodeGenericFuncDesc;
-import org.apache.hadoop.hive.ql.plan.groupByDesc;
-import org.apache.hadoop.hive.ql.udf.*;
-import org.apache.hadoop.hive.ql.udf.generic.*;
+import org.apache.hadoop.hive.ql.udf.UDAFMax;
+import org.apache.hadoop.hive.ql.udf.UDAFMin;
+import org.apache.hadoop.hive.ql.udf.UDFAbs;
+import org.apache.hadoop.hive.ql.udf.UDFAcos;
+import org.apache.hadoop.hive.ql.udf.UDFAscii;
+import org.apache.hadoop.hive.ql.udf.UDFAsin;
+import org.apache.hadoop.hive.ql.udf.UDFBin;
+import org.apache.hadoop.hive.ql.udf.UDFCeil;
+import org.apache.hadoop.hive.ql.udf.UDFConcat;
+import org.apache.hadoop.hive.ql.udf.UDFConv;
+import org.apache.hadoop.hive.ql.udf.UDFCos;
+import org.apache.hadoop.hive.ql.udf.UDFDate;
+import org.apache.hadoop.hive.ql.udf.UDFDateAdd;
+import org.apache.hadoop.hive.ql.udf.UDFDateDiff;
+import org.apache.hadoop.hive.ql.udf.UDFDateSub;
+import org.apache.hadoop.hive.ql.udf.UDFDayOfMonth;
+import org.apache.hadoop.hive.ql.udf.UDFExp;
+import org.apache.hadoop.hive.ql.udf.UDFFindInSet;
+import org.apache.hadoop.hive.ql.udf.UDFFloor;
+import org.apache.hadoop.hive.ql.udf.UDFFromUnixTime;
+import org.apache.hadoop.hive.ql.udf.UDFHex;
+import org.apache.hadoop.hive.ql.udf.UDFHour;
+import org.apache.hadoop.hive.ql.udf.UDFJson;
+import org.apache.hadoop.hive.ql.udf.UDFLTrim;
+import org.apache.hadoop.hive.ql.udf.UDFLength;
+import org.apache.hadoop.hive.ql.udf.UDFLike;
+import org.apache.hadoop.hive.ql.udf.UDFLn;
+import org.apache.hadoop.hive.ql.udf.UDFLog;
+import org.apache.hadoop.hive.ql.udf.UDFLog10;
+import org.apache.hadoop.hive.ql.udf.UDFLog2;
+import org.apache.hadoop.hive.ql.udf.UDFLower;
+import org.apache.hadoop.hive.ql.udf.UDFLpad;
+import org.apache.hadoop.hive.ql.udf.UDFMinute;
+import org.apache.hadoop.hive.ql.udf.UDFMonth;
+import org.apache.hadoop.hive.ql.udf.UDFOPAnd;
+import org.apache.hadoop.hive.ql.udf.UDFOPBitAnd;
+import org.apache.hadoop.hive.ql.udf.UDFOPBitNot;
+import org.apache.hadoop.hive.ql.udf.UDFOPBitOr;
+import org.apache.hadoop.hive.ql.udf.UDFOPBitXor;
+import org.apache.hadoop.hive.ql.udf.UDFOPDivide;
+import org.apache.hadoop.hive.ql.udf.UDFOPEqual;
+import org.apache.hadoop.hive.ql.udf.UDFOPEqualOrGreaterThan;
+import org.apache.hadoop.hive.ql.udf.UDFOPEqualOrLessThan;
+import org.apache.hadoop.hive.ql.udf.UDFOPGreaterThan;
+import org.apache.hadoop.hive.ql.udf.UDFOPLessThan;
+import org.apache.hadoop.hive.ql.udf.UDFOPLongDivide;
+import org.apache.hadoop.hive.ql.udf.UDFOPMinus;
+import org.apache.hadoop.hive.ql.udf.UDFOPMod;
+import org.apache.hadoop.hive.ql.udf.UDFOPMultiply;
+import org.apache.hadoop.hive.ql.udf.UDFOPNegative;
+import org.apache.hadoop.hive.ql.udf.UDFOPNot;
+import org.apache.hadoop.hive.ql.udf.UDFOPNotEqual;
+import org.apache.hadoop.hive.ql.udf.UDFOPOr;
+import org.apache.hadoop.hive.ql.udf.UDFOPPlus;
+import org.apache.hadoop.hive.ql.udf.UDFOPPositive;
+import org.apache.hadoop.hive.ql.udf.UDFParseUrl;
+import org.apache.hadoop.hive.ql.udf.UDFPosMod;
+import org.apache.hadoop.hive.ql.udf.UDFPower;
+import org.apache.hadoop.hive.ql.udf.UDFRTrim;
+import org.apache.hadoop.hive.ql.udf.UDFRand;
+import org.apache.hadoop.hive.ql.udf.UDFRegExp;
+import org.apache.hadoop.hive.ql.udf.UDFRegExpExtract;
+import org.apache.hadoop.hive.ql.udf.UDFRegExpReplace;
+import org.apache.hadoop.hive.ql.udf.UDFRepeat;
+import org.apache.hadoop.hive.ql.udf.UDFReverse;
+import org.apache.hadoop.hive.ql.udf.UDFRound;
+import org.apache.hadoop.hive.ql.udf.UDFRpad;
+import org.apache.hadoop.hive.ql.udf.UDFSecond;
+import org.apache.hadoop.hive.ql.udf.UDFSin;
+import org.apache.hadoop.hive.ql.udf.UDFSpace;
+import org.apache.hadoop.hive.ql.udf.UDFSqrt;
+import org.apache.hadoop.hive.ql.udf.UDFSubstr;
+import org.apache.hadoop.hive.ql.udf.UDFToBoolean;
+import org.apache.hadoop.hive.ql.udf.UDFToByte;
+import org.apache.hadoop.hive.ql.udf.UDFToDouble;
+import org.apache.hadoop.hive.ql.udf.UDFToFloat;
+import org.apache.hadoop.hive.ql.udf.UDFToInteger;
+import org.apache.hadoop.hive.ql.udf.UDFToLong;
+import org.apache.hadoop.hive.ql.udf.UDFToShort;
+import org.apache.hadoop.hive.ql.udf.UDFToString;
+import org.apache.hadoop.hive.ql.udf.UDFTrim;
+import org.apache.hadoop.hive.ql.udf.UDFType;
+import org.apache.hadoop.hive.ql.udf.UDFUnhex;
+import org.apache.hadoop.hive.ql.udf.UDFUnixTimeStamp;
+import org.apache.hadoop.hive.ql.udf.UDFUpper;
+import org.apache.hadoop.hive.ql.udf.UDFWeekOfYear;
+import org.apache.hadoop.hive.ql.udf.UDFYear;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFAverage;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFBridge;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFCount;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEvaluator;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFStd;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFStdSample;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFSum;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFResolver;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFVariance;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDAFVarianceSample;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDF;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFArray;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFCase;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFCoalesce;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFConcatWS;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFElt;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFField;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFHash;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFIf;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFIndex;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFInstr;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFLocate;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFMap;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNotNull;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPNull;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFSize;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFSplit;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDTF;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDFWhen;
+import org.apache.hadoop.hive.ql.udf.generic.GenericUDTFExplode;
import org.apache.hadoop.hive.serde.Constants;
import org.apache.hadoop.hive.serde2.objectinspector.ObjectInspector.Category;
import org.apache.hadoop.hive.serde2.typeinfo.ListTypeInfo;
@@ -151,6 +267,7 @@
registerUDF("=", UDFOPEqual.class, true);
registerUDF("==", UDFOPEqual.class, true, "=");
registerUDF("<>", UDFOPNotEqual.class, true);
+ registerUDF("!=", UDFOPNotEqual.class, true, "<>");
registerUDF("<", UDFOPLessThan.class, true);
registerUDF("<=", UDFOPEqualOrLessThan.class, true);
registerUDF(">", UDFOPGreaterThan.class, true);
@@ -304,11 +421,11 @@
* Returns a set of registered function names.
* This is used for the CLI command "SHOW FUNCTIONS 'regular expression';"
* Returns an empty set when the regular expression is not valid.
- * @param funcPatternStr regular expression of the intersted function names
+ * @param funcPatternStr regular expression of the interested function names
* @return set of strings contains function names
*/
public static Set<String> getFunctionNames(String funcPatternStr) {
- TreeSet<String> funcNames = new TreeSet<String>();
+ Set<String> funcNames = new TreeSet<String>();
Pattern funcPattern = null;
try {
funcPattern = Pattern.compile(funcPatternStr);
@@ -323,6 +440,33 @@
return funcNames;
}
+ /**
+ * Returns the set of synonyms of the supplied function.
+ * @param funcName the name of the function
+ * @return Set of synonyms for funcName
+ */
+ public static Set<String> getFunctionSynonyms(String funcName) {
+ Set<String> synonyms = new HashSet<String>();
+
+ FunctionInfo funcInfo = getFunctionInfo(funcName);
+ if (null == funcInfo) {
+ return synonyms;
+ }
+
+ Class<?> funcClass = funcInfo.getFunctionClass();
+ for (String name : mFunctions.keySet()) {
+ if (name.equals(funcName)) {
+ continue;
+ }
+ if (mFunctions.get(name).getFunctionClass().equals(funcClass)) {
+ synonyms.add(name);
+ }
+ }
+
+ return synonyms;
+ }
+
+
static Map<TypeInfo, Integer> numericTypes = new HashMap<TypeInfo, Integer>();
static List<TypeInfo> numericTypeList = new ArrayList<TypeInfo>();
static void registerNumericType(String typeName, int level) {
@@ -429,7 +573,7 @@
public static <T> Method getMethodInternal(Class<? extends T> udfClass, String methodName, boolean exact,
List<TypeInfo> argumentClasses) {
- ArrayList<Method> mlist = new ArrayList<Method>();
+ List<Method> mlist = new ArrayList<Method>();
for(Method m: Arrays.asList(udfClass.getMethods())) {
if (m.getName().equals(methodName)) {
@@ -574,7 +718,7 @@
* @param argumentsPassed The classes for the argument.
* @return The matching method.
*/
- public static Method getMethodInternal(ArrayList<Method> mlist, boolean exact,
+ public static Method getMethodInternal(List<Method> mlist, boolean exact,
List<TypeInfo> argumentsPassed) {
int leastConversionCost = Integer.MAX_VALUE;
Method udfMethod = null;
Modified: hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g (original)
+++ hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g Thu Jan 7 21:54:33 2010
@@ -1305,6 +1305,18 @@
| KW_NOT
| KW_LIKE
| KW_IF
+ | KW_CASE
+ | KW_WHEN
+ | KW_TINYINT
+ | KW_SMALLINT
+ | KW_INT
+ | KW_BIGINT
+ | KW_FLOAT
+ | KW_DOUBLE
+ | KW_BOOLEAN
+ | KW_STRING
+ | KW_ARRAY
+ | KW_MAP
| EQUAL
| NOTEQUAL
| LESSTHANOREQUALTO
@@ -1338,7 +1350,7 @@
KW_ALL : 'ALL';
KW_AND : 'AND';
KW_OR : 'OR';
-KW_NOT : 'NOT';
+KW_NOT : 'NOT' | '!';
KW_LIKE : 'LIKE';
KW_IF : 'IF';
@@ -1522,8 +1534,8 @@
LCURLY : '{';
RCURLY : '}';
-EQUAL : '=';
-NOTEQUAL : '<>';
+EQUAL : '=' | '==';
+NOTEQUAL : '<>' | '!=';
LESSTHANOREQUALTO : '<=';
LESSTHAN : '<';
GREATERTHANOREQUALTO : '>=';
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_function.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_function.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_function.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/describe_function.q Thu Jan 7 21:54:33 2010
@@ -1,168 +0,0 @@
-DESCRIBE FUNCTION concat;
-DESCRIBE FUNCTION substr;
-DESCRIBE FUNCTION substring;
-DESCRIBE FUNCTION find_in_set;
-DESCRIBE FUNCTION space;
-DESCRIBE FUNCTION repeat;
-DESCRIBE FUNCTION ascii;
-DESCRIBE FUNCTION lpad;
-DESCRIBE FUNCTION rpad;
-DESCRIBE FUNCTION size;
-DESCRIBE FUNCTION round;
-DESCRIBE FUNCTION floor;
-DESCRIBE FUNCTION sqrt;
-DESCRIBE FUNCTION ceil;
-DESCRIBE FUNCTION ceiling;
-DESCRIBE FUNCTION rand;
-DESCRIBE FUNCTION abs;
-DESCRIBE FUNCTION pmod;
-DESCRIBE FUNCTION ln;
-DESCRIBE FUNCTION log2;
-DESCRIBE FUNCTION sin;
-DESCRIBE FUNCTION asin;
-DESCRIBE FUNCTION cos;
-DESCRIBE FUNCTION acos;
-DESCRIBE FUNCTION log10;
-DESCRIBE FUNCTION log;
-DESCRIBE FUNCTION exp;
-DESCRIBE FUNCTION power;
-DESCRIBE FUNCTION pow;
-DESCRIBE FUNCTION conv;
-DESCRIBE FUNCTION bin;
-DESCRIBE FUNCTION hex;
-DESCRIBE FUNCTION unhex;
-DESCRIBE FUNCTION upper;
-DESCRIBE FUNCTION lower;
-DESCRIBE FUNCTION ucase;
-DESCRIBE FUNCTION lcase;
-DESCRIBE FUNCTION trim;
-DESCRIBE FUNCTION ltrim;
-DESCRIBE FUNCTION rtrim;
-DESCRIBE FUNCTION length;
-DESCRIBE FUNCTION reverse;
-DESCRIBE FUNCTION like;
-DESCRIBE FUNCTION rlike;
-DESCRIBE FUNCTION regexp;
-DESCRIBE FUNCTION regexp_replace;
-DESCRIBE FUNCTION regexp_extract;
-DESCRIBE FUNCTION parse_url;
-DESCRIBE FUNCTION split;
-DESCRIBE FUNCTION positive;
-DESCRIBE FUNCTION negative;
-DESCRIBE FUNCTION day;
-DESCRIBE FUNCTION dayofmonth;
-DESCRIBE FUNCTION month;
-DESCRIBE FUNCTION year;
-DESCRIBE FUNCTION from_unixtime;
-DESCRIBE FUNCTION unix_timestamp;
-DESCRIBE FUNCTION to_date;
-DESCRIBE FUNCTION date_add;
-DESCRIBE FUNCTION date_sub;
-DESCRIBE FUNCTION datediff;
-DESCRIBE FUNCTION get_json_object;
-DESCRIBE FUNCTION +;
-DESCRIBE FUNCTION -;
-DESCRIBE FUNCTION *;
-DESCRIBE FUNCTION /;
-DESCRIBE FUNCTION %;
-DESCRIBE FUNCTION div;
-DESCRIBE FUNCTION &;
-DESCRIBE FUNCTION |;
-DESCRIBE FUNCTION ^;
-DESCRIBE FUNCTION ~;
-DESCRIBE FUNCTION =;
-DESCRIBE FUNCTION <>;
-DESCRIBE FUNCTION <;
-DESCRIBE FUNCTION <=;
-DESCRIBE FUNCTION >;
-DESCRIBE FUNCTION >=;
-DESCRIBE FUNCTION and;
-DESCRIBE FUNCTION or;
-DESCRIBE FUNCTION not;
-DESCRIBE FUNCTION isnull;
-DESCRIBE FUNCTION isnotnull;
-
-
-DESCRIBE FUNCTION EXTENDED concat;
-DESCRIBE FUNCTION EXTENDED substr;
-DESCRIBE FUNCTION EXTENDED substring;
-DESCRIBE FUNCTION EXTENDED find_in_set;
-DESCRIBE FUNCTION EXTENDED space;
-DESCRIBE FUNCTION EXTENDED repeat;
-DESCRIBE FUNCTION EXTENDED ascii;
-DESCRIBE FUNCTION EXTENDED lpad;
-DESCRIBE FUNCTION EXTENDED rpad;
-DESCRIBE FUNCTION EXTENDED size;
-DESCRIBE FUNCTION EXTENDED round;
-DESCRIBE FUNCTION EXTENDED floor;
-DESCRIBE FUNCTION EXTENDED sqrt;
-DESCRIBE FUNCTION EXTENDED ceil;
-DESCRIBE FUNCTION EXTENDED ceiling;
-DESCRIBE FUNCTION EXTENDED rand;
-DESCRIBE FUNCTION EXTENDED abs;
-DESCRIBE FUNCTION EXTENDED pmod;
-DESCRIBE FUNCTION EXTENDED ln;
-DESCRIBE FUNCTION EXTENDED log2;
-DESCRIBE FUNCTION EXTENDED sin;
-DESCRIBE FUNCTION EXTENDED asin;
-DESCRIBE FUNCTION EXTENDED cos;
-DESCRIBE FUNCTION EXTENDED acos;
-DESCRIBE FUNCTION EXTENDED log10;
-DESCRIBE FUNCTION EXTENDED log;
-DESCRIBE FUNCTION EXTENDED exp;
-DESCRIBE FUNCTION EXTENDED power;
-DESCRIBE FUNCTION EXTENDED pow;
-DESCRIBE FUNCTION EXTENDED conv;
-DESCRIBE FUNCTION EXTENDED bin;
-DESCRIBE FUNCTION EXTENDED hex;
-DESCRIBE FUNCTION EXTENDED unhex;
-DESCRIBE FUNCTION EXTENDED upper;
-DESCRIBE FUNCTION EXTENDED lower;
-DESCRIBE FUNCTION EXTENDED ucase;
-DESCRIBE FUNCTION EXTENDED lcase;
-DESCRIBE FUNCTION EXTENDED trim;
-DESCRIBE FUNCTION EXTENDED ltrim;
-DESCRIBE FUNCTION EXTENDED rtrim;
-DESCRIBE FUNCTION EXTENDED length;
-DESCRIBE FUNCTION EXTENDED reverse;
-DESCRIBE FUNCTION EXTENDED like;
-DESCRIBE FUNCTION EXTENDED rlike;
-DESCRIBE FUNCTION EXTENDED regexp;
-DESCRIBE FUNCTION EXTENDED regexp_replace;
-DESCRIBE FUNCTION EXTENDED regexp_extract;
-DESCRIBE FUNCTION EXTENDED parse_url;
-DESCRIBE FUNCTION EXTENDED split;
-DESCRIBE FUNCTION EXTENDED positive;
-DESCRIBE FUNCTION EXTENDED negative;
-DESCRIBE FUNCTION EXTENDED day;
-DESCRIBE FUNCTION EXTENDED dayofmonth;
-DESCRIBE FUNCTION EXTENDED month;
-DESCRIBE FUNCTION EXTENDED year;
-DESCRIBE FUNCTION EXTENDED from_unixtime;
-DESCRIBE FUNCTION EXTENDED unix_timestamp;
-DESCRIBE FUNCTION EXTENDED to_date;
-DESCRIBE FUNCTION EXTENDED date_add;
-DESCRIBE FUNCTION EXTENDED date_sub;
-DESCRIBE FUNCTION EXTENDED datediff;
-DESCRIBE FUNCTION EXTENDED get_json_object;
-DESCRIBE FUNCTION EXTENDED +;
-DESCRIBE FUNCTION EXTENDED -;
-DESCRIBE FUNCTION EXTENDED *;
-DESCRIBE FUNCTION EXTENDED /;
-DESCRIBE FUNCTION EXTENDED %;
-DESCRIBE FUNCTION EXTENDED div;
-DESCRIBE FUNCTION EXTENDED &;
-DESCRIBE FUNCTION EXTENDED |;
-DESCRIBE FUNCTION EXTENDED ^;
-DESCRIBE FUNCTION EXTENDED ~;
-DESCRIBE FUNCTION EXTENDED =;
-DESCRIBE FUNCTION EXTENDED <>;
-DESCRIBE FUNCTION EXTENDED <;
-DESCRIBE FUNCTION EXTENDED <=;
-DESCRIBE FUNCTION EXTENDED >;
-DESCRIBE FUNCTION EXTENDED >=;
-DESCRIBE FUNCTION EXTENDED and;
-DESCRIBE FUNCTION EXTENDED or;
-DESCRIBE FUNCTION EXTENDED not;
-DESCRIBE FUNCTION EXTENDED isnull;
-DESCRIBE FUNCTION EXTENDED isnotnull;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_avg.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_avg.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_avg.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_avg.q Thu Jan 7 21:54:33 2010
@@ -1,4 +0,0 @@
-DESCRIBE FUNCTION avg;
-DESCRIBE FUNCTION EXTENDED avg;
-DESCRIBE FUNCTION avg;
-DESCRIBE FUNCTION EXTENDED avg;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_count.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_count.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_count.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_count.q Thu Jan 7 21:54:33 2010
@@ -1,4 +0,0 @@
-DESCRIBE FUNCTION count;
-DESCRIBE FUNCTION EXTENDED count;
-DESCRIBE FUNCTION count;
-DESCRIBE FUNCTION EXTENDED count;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_max.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_max.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_max.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_max.q Thu Jan 7 21:54:33 2010
@@ -1,4 +0,0 @@
-DESCRIBE FUNCTION max;
-DESCRIBE FUNCTION EXTENDED max;
-DESCRIBE FUNCTION max;
-DESCRIBE FUNCTION EXTENDED max;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_min.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_min.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_min.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_min.q Thu Jan 7 21:54:33 2010
@@ -1,4 +0,0 @@
-DESCRIBE FUNCTION min;
-DESCRIBE FUNCTION EXTENDED min;
-DESCRIBE FUNCTION min;
-DESCRIBE FUNCTION EXTENDED min;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_std.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_std.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_std.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_std.q Thu Jan 7 21:54:33 2010
@@ -1,16 +0,0 @@
-DESCRIBE FUNCTION std;
-DESCRIBE FUNCTION EXTENDED std;
-
-DESCRIBE FUNCTION stddev;
-DESCRIBE FUNCTION EXTENDED stddev;
-
-DESCRIBE FUNCTION stddev_pop;
-DESCRIBE FUNCTION EXTENDED stddev_pop;
-DESCRIBE FUNCTION std;
-DESCRIBE FUNCTION EXTENDED std;
-
-DESCRIBE FUNCTION stddev;
-DESCRIBE FUNCTION EXTENDED stddev;
-
-DESCRIBE FUNCTION stddev_pop;
-DESCRIBE FUNCTION EXTENDED stddev_pop;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_stddev_samp.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_stddev_samp.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_stddev_samp.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_stddev_samp.q Thu Jan 7 21:54:33 2010
@@ -1,4 +0,0 @@
-DESCRIBE FUNCTION stddev_samp;
-DESCRIBE FUNCTION EXTENDED stddev_samp;
-DESCRIBE FUNCTION stddev_samp;
-DESCRIBE FUNCTION EXTENDED stddev_samp;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_sum.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_sum.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_sum.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_sum.q Thu Jan 7 21:54:33 2010
@@ -1,6 +0,0 @@
-DESCRIBE FUNCTION sum;
-DESCRIBE FUNCTION EXTENDED sum;
-
-DESCRIBE FUNCTION sum;
-DESCRIBE FUNCTION EXTENDED sum;
-
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_var_samp.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_var_samp.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_var_samp.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_var_samp.q Thu Jan 7 21:54:33 2010
@@ -1,4 +0,0 @@
-DESCRIBE FUNCTION var_samp;
-DESCRIBE FUNCTION EXTENDED var_samp;
-DESCRIBE FUNCTION var_samp;
-DESCRIBE FUNCTION EXTENDED var_samp;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_variance.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_variance.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_variance.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udaf_variance.q Thu Jan 7 21:54:33 2010
@@ -1,10 +0,0 @@
-DESCRIBE FUNCTION variance;
-DESCRIBE FUNCTION EXTENDED variance;
-
-DESCRIBE FUNCTION var_pop;
-DESCRIBE FUNCTION EXTENDED var_pop;
-DESCRIBE FUNCTION variance;
-DESCRIBE FUNCTION EXTENDED variance;
-
-DESCRIBE FUNCTION var_pop;
-DESCRIBE FUNCTION EXTENDED var_pop;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_add.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_add.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_add.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_add.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION +;
+DESCRIBE FUNCTION EXTENDED +;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_array.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_array.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_array.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_array.q Thu Jan 7 21:54:33 2010
@@ -1,6 +1,5 @@
--- Parsing bug requires us to quote array
-DESCRIBE FUNCTION 'array';
-DESCRIBE FUNCTION EXTENDED 'array';
+DESCRIBE FUNCTION array;
+DESCRIBE FUNCTION EXTENDED array;
EXPLAIN SELECT array(), array()[1], array(1, 2, 3), array(1, 2, 3)[2], array(1,"a", 2, 3), array(1,"a", 2, 3)[2],
array(array(1), array(2), array(3), array(4))[1][0] FROM src LIMIT 1;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_avg.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_avg.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_avg.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_avg.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION avg;
+DESCRIBE FUNCTION EXTENDED avg;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bigint.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bigint.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bigint.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bigint.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION bigint;
+DESCRIBE FUNCTION EXTENDED bigint;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_and.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_and.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_and.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_and.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION &;
+DESCRIBE FUNCTION EXTENDED &;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_not.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_not.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_not.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_not.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION ~;
+DESCRIBE FUNCTION EXTENDED ~;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_or.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_or.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_or.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_or.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION |;
+DESCRIBE FUNCTION EXTENDED |;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_xor.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_xor.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_xor.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_bitwise_xor.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION ^;
+DESCRIBE FUNCTION EXTENDED ^;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_boolean.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_boolean.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_boolean.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_boolean.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION boolean;
+DESCRIBE FUNCTION EXTENDED boolean;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_case.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_case.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_case.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_case.q Thu Jan 7 21:54:33 2010
@@ -1,6 +1,5 @@
--- Parsing bug requires us to quote case
-DESCRIBE FUNCTION 'case';
-DESCRIBE FUNCTION EXTENDED 'case';
+DESCRIBE FUNCTION case;
+DESCRIBE FUNCTION EXTENDED case;
EXPLAIN
SELECT CASE 1
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceil.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceil.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceil.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceil.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION ceil;
+DESCRIBE FUNCTION EXTENDED ceil;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceiling.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceiling.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceiling.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ceiling.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION ceiling;
+DESCRIBE FUNCTION EXTENDED ceiling;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_count.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_count.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_count.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_count.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION count;
+DESCRIBE FUNCTION EXTENDED count;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_add.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_add.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_add.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_add.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION date_add;
+DESCRIBE FUNCTION EXTENDED date_add;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_sub.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_sub.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_sub.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_date_sub.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION date_sub;
+DESCRIBE FUNCTION EXTENDED date_sub;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_datediff.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_datediff.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_datediff.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_datediff.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION datediff;
+DESCRIBE FUNCTION EXTENDED datediff;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_day.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_day.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_day.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_day.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION day;
+DESCRIBE FUNCTION EXTENDED day;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_dayofmonth.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_dayofmonth.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_dayofmonth.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_dayofmonth.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION dayofmonth;
+DESCRIBE FUNCTION EXTENDED dayofmonth;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_div.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_div.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_div.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_div.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,4 @@
+DESCRIBE FUNCTION div;
+DESCRIBE FUNCTION EXTENDED div;
+
+SELECT 3 DIV 2 FROM SRC LIMIT 1;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divide.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divide.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divide.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divide.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,4 @@
+DESCRIBE FUNCTION /;
+DESCRIBE FUNCTION EXTENDED /;
+
+SELECT 3 / 2 FROM SRC LIMIT 1;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divider.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divider.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divider.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_divider.q Thu Jan 7 21:54:33 2010
@@ -1,6 +0,0 @@
-DESCRIBE FUNCTION div;
-DESCRIBE FUNCTION EXTENDED div;
-
-SELECT 3 / 2 FROM SRC LIMIT 1;
-
-SELECT 3 DIV 2 FROM SRC LIMIT 1;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_double.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_double.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_double.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_double.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION double;
+DESCRIBE FUNCTION EXTENDED double;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_equal.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_equal.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_equal.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_equal.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,6 @@
+DESCRIBE FUNCTION =;
+DESCRIBE FUNCTION EXTENDED =;
+
+DESCRIBE FUNCTION ==;
+DESCRIBE FUNCTION EXTENDED ==;
+
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_exp.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_exp.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_exp.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_exp.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION exp;
+DESCRIBE FUNCTION EXTENDED exp;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_explode.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_explode.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_explode.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_explode.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,9 @@
+DESCRIBE FUNCTION explode;
+DESCRIBE FUNCTION EXTENDED explode;
+
+EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
+EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;
+
+SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
+SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3;
+SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_float.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_float.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_float.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_float.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION float;
+DESCRIBE FUNCTION EXTENDED float;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_floor.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_floor.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_floor.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_floor.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION floor;
+DESCRIBE FUNCTION EXTENDED floor;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_from_unixtime.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_from_unixtime.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_from_unixtime.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_from_unixtime.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION from_unixtime;
+DESCRIBE FUNCTION EXTENDED from_unixtime;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_get_json_object.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,25 @@
+DESCRIBE FUNCTION get_json_object;
+DESCRIBE FUNCTION EXTENDED get_json_object;
+
+CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE;
+
+FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86;
+
+EXPLAIN
+SELECT get_json_object(src_json.json, '$.owner') FROM src_json;
+
+SELECT get_json_object(src_json.json, '$') FROM src_json;
+
+SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json;
+
+SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json;
+
+SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json;
+
+SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json;
+
+SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age') FROM src_json;
+
+SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json;
+
+SELECT get_json_object(src_json.json, '$.non_exist_key'), get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthan.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION >;
+DESCRIBE FUNCTION EXTENDED >;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_greaterthanorequal.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION >=;
+DESCRIBE FUNCTION EXTENDED >=;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,9 @@
+DESCRIBE FUNCTION hour;
+DESCRIBE FUNCTION EXTENDED hour;
+
+EXPLAIN
+SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07')
+FROM src WHERE key = 86;
+
+SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07')
+FROM src WHERE key = 86;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour_minute_second.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour_minute_second.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour_minute_second.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_hour_minute_second.q Thu Jan 7 21:54:33 2010
@@ -1,20 +0,0 @@
-DESCRIBE FUNCTION hour;
-DESCRIBE FUNCTION minute;
-DESCRIBE FUNCTION second;
-
-
-DESCRIBE FUNCTION EXTENDED hour;
-DESCRIBE FUNCTION EXTENDED minute;
-DESCRIBE FUNCTION EXTENDED second;
-
-
-EXPLAIN
-SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
- minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
- second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
-FROM src WHERE key = 86;
-
-SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
- minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
- second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
-FROM src WHERE key = 86;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_index.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_index.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_index.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_index.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION index;
+DESCRIBE FUNCTION EXTENDED index;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_int.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_int.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_int.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_int.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION int;
+DESCRIBE FUNCTION EXTENDED int;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnotnull.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnotnull.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnotnull.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnotnull.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION isnotnull;
+DESCRIBE FUNCTION EXTENDED isnotnull;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnull.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnull.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnull.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_isnull.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION isnull;
+DESCRIBE FUNCTION EXTENDED isnull;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_json.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_json.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_json.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_json.q Thu Jan 7 21:54:33 2010
@@ -1,25 +0,0 @@
-DESCRIBE FUNCTION get_json_object;
-DESCRIBE FUNCTION EXTENDED get_json_object;
-
-CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE;
-
-FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86;
-
-EXPLAIN
-SELECT get_json_object(src_json.json, '$.owner') FROM src_json;
-
-SELECT get_json_object(src_json.json, '$') FROM src_json;
-
-SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json;
-
-SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json;
-
-SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json;
-
-SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json;
-
-SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age') FROM src_json;
-
-SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json;
-
-SELECT get_json_object(src_json.json, '$.non_exist_key'), get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lcase.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lcase.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lcase.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lcase.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,3 @@
+DESCRIBE FUNCTION lcase;
+DESCRIBE FUNCTION EXTENDED lcase;
+
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthan.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION <;
+DESCRIBE FUNCTION EXTENDED <;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lessthanorequal.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION <=;
+DESCRIBE FUNCTION EXTENDED <=;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ln.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ln.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ln.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ln.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION ln;
+DESCRIBE FUNCTION EXTENDED ln;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION log;
+DESCRIBE FUNCTION EXTENDED log;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log10.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log10.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log10.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log10.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION log10;
+DESCRIBE FUNCTION EXTENDED log10;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log2.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log2.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log2.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_log2.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION log2;
+DESCRIBE FUNCTION EXTENDED log2;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+DESCRIBE FUNCTION lpad;
+DESCRIBE FUNCTION EXTENDED lpad;
+
+EXPLAIN SELECT
+ lpad('hi', 1, '?'),
+ lpad('hi', 5, '.'),
+ lpad('hi', 6, '123')
+FROM src LIMIT 1;
+
+SELECT
+ lpad('hi', 1, '?'),
+ lpad('hi', 5, '.'),
+ lpad('hi', 6, '123')
+FROM src LIMIT 1;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad_rpad.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad_rpad.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad_rpad.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_lpad_rpad.q Thu Jan 7 21:54:33 2010
@@ -1,29 +0,0 @@
-DESCRIBE FUNCTION lpad;
-DESCRIBE FUNCTION EXTENDED lpad;
-
-DESCRIBE FUNCTION rpad;
-DESCRIBE FUNCTION EXTENDED rpad;
-
-EXPLAIN SELECT
- lpad('hi', 1, '?'),
- lpad('hi', 5, '.'),
- lpad('hi', 6, '123')
-FROM src LIMIT 1;
-
-SELECT
- lpad('hi', 1, '?'),
- lpad('hi', 5, '.'),
- lpad('hi', 6, '123')
-FROM src LIMIT 1;
-
-EXPLAIN SELECT
- rpad('hi', 1, '?'),
- rpad('hi', 5, '.'),
- rpad('hi', 6, '123')
-FROM src LIMIT 1;
-
-SELECT
- rpad('hi', 1, '?'),
- rpad('hi', 5, '.'),
- rpad('hi', 6, '123')
-FROM src LIMIT 1;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ltrim.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ltrim.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ltrim.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_ltrim.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION ltrim;
+DESCRIBE FUNCTION EXTENDED ltrim;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_map.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_map.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_map.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_map.q Thu Jan 7 21:54:33 2010
@@ -1,6 +1,5 @@
--- Parsing bug requires us to quote map
-DESCRIBE FUNCTION 'map';
-DESCRIBE FUNCTION EXTENDED 'map';
+DESCRIBE FUNCTION map;
+DESCRIBE FUNCTION EXTENDED map;
EXPLAIN SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_max.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_max.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_max.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_max.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION max;
+DESCRIBE FUNCTION EXTENDED max;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_min.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_min.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_min.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_min.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION min;
+DESCRIBE FUNCTION EXTENDED min;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_minute.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_minute.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_minute.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_minute.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,9 @@
+DESCRIBE FUNCTION minute;
+DESCRIBE FUNCTION EXTENDED minute;
+
+EXPLAIN
+SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
+FROM src WHERE key = 86;
+
+SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
+FROM src WHERE key = 86;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_modulo.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_modulo.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_modulo.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_modulo.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION %;
+DESCRIBE FUNCTION EXTENDED %;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_month.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_month.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_month.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_month.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION minute;
+DESCRIBE FUNCTION EXTENDED minute;
Modified: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_negative.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_negative.q?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_negative.q (original)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_negative.q Thu Jan 7 21:54:33 2010
@@ -1,6 +1,10 @@
DESCRIBE FUNCTION negative;
DESCRIBE FUNCTION EXTENDED negative;
+-- synonym
+DESCRIBE FUNCTION -;
+DESCRIBE FUNCTION EXTENDED -;
+
select - null from src limit 1;
select - cast(null as int) from src limit 1;
select - cast(null as smallint) from src limit 1;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_not.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_not.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_not.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_not.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,6 @@
+DESCRIBE FUNCTION not;
+DESCRIBE FUNCTION EXTENDED not;
+
+-- synonym
+DESCRIBE FUNCTION !;
+DESCRIBE FUNCTION EXTENDED !;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_notequal.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_notequal.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_notequal.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_notequal.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,23 @@
+DESCRIBE FUNCTION <>;
+DESCRIBE FUNCTION EXTENDED <>;
+
+DESCRIBE FUNCTION !=;
+DESCRIBE FUNCTION EXTENDED !=;
+
+EXPLAIN
+SELECT key, value
+FROM src
+WHERE key <> '302';
+
+SELECT key, value
+FROM src
+WHERE key <> '302';
+
+EXPLAIN
+SELECT key, value
+FROM src
+WHERE key != '302';
+
+SELECT key, value
+FROM src
+WHERE key != '302';
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_or.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_or.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_or.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_or.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION or;
+DESCRIBE FUNCTION EXTENDED or;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_positive.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_positive.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_positive.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_positive.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,6 @@
+DESCRIBE FUNCTION positive;
+DESCRIBE FUNCTION EXTENDED positive;
+
+-- synonym
+DESCRIBE FUNCTION +;
+DESCRIBE FUNCTION EXTENDED +;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_pow.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_pow.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_pow.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_pow.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION pow;
+DESCRIBE FUNCTION EXTENDED pow;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_power.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_power.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_power.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_power.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION power;
+DESCRIBE FUNCTION EXTENDED power;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rand.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rand.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rand.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rand.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION rand;
+DESCRIBE FUNCTION EXTENDED rand;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_extract.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_extract.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_extract.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_extract.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION regexp_extract;
+DESCRIBE FUNCTION EXTENDED regexp_extract;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_replace.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_replace.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_replace.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_regexp_replace.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION regexp_replace;
+DESCRIBE FUNCTION EXTENDED regexp_replace;
\ No newline at end of file
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rlike.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rlike.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rlike.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rlike.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,2 @@
+DESCRIBE FUNCTION rlike;
+DESCRIBE FUNCTION EXTENDED rlike;
Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rpad.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rpad.q?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rpad.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/udf_rpad.q Thu Jan 7 21:54:33 2010
@@ -0,0 +1,14 @@
+DESCRIBE FUNCTION rpad;
+DESCRIBE FUNCTION EXTENDED rpad;
+
+EXPLAIN SELECT
+ rpad('hi', 1, '?'),
+ rpad('hi', 5, '.'),
+ rpad('hi', 6, '123')
+FROM src LIMIT 1;
+
+SELECT
+ rpad('hi', 1, '?'),
+ rpad('hi', 5, '.'),
+ rpad('hi', 6, '123')
+FROM src LIMIT 1;