[
https://issues.apache.org/jira/browse/HIVE-682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762475#action_12762475
]
Namit Jain commented on HIVE-682:
---------------------------------
Index: ql/src/test/queries/clientpositive/udf_concat_ws.q
===================================================================
--- ql/src/test/queries/clientpositive/udf_concat_ws.q (revision 0)
+++ ql/src/test/queries/clientpositive/udf_concat_ws.q (revision 0)
@@ -0,0 +1,15 @@
+CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING);
+
+FROM src INSERT OVERWRITE TABLE dest1 SELECT 'abc', 'xyz', '8675309' WHERE
src.key = 86;
+
+EXPLAIN
+SELECT concat_ws(dest1.c1, dest1.c2, dest1.c3),
+ concat_ws(',', dest1.c1, dest1.c2, dest1.c3),
+ concat_ws(NULL, dest1.c1, dest1.c2, dest1.c3),
+ concat_ws('**', dest1.c1, NULL, dest1.c3) FROM dest1;
+
+SELECT concat_ws(dest1.c1, dest1.c2, dest1.c3),
+ concat_ws(',', dest1.c1, dest1.c2, dest1.c3),
+ concat_ws(NULL, dest1.c1, dest1.c2, dest1.c3),
+ concat_ws('**', dest1.c1, NULL, dest1.c3) FROM dest1;
Please add the following in the above test:
describe function concat_ws;
describe function extended concat_ws;
> add UDF concat_ws
> -----------------
>
> Key: HIVE-682
> URL: https://issues.apache.org/jira/browse/HIVE-682
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Jonathan Chang
> Attachments: concat_ws.patch, concat_ws.patch, concat_ws.patch
>
>
> add UDF concat_ws
> look at
> http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html
> for details
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
