[
https://issues.apache.org/jira/browse/EAGLE-85?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15055790#comment-15055790
]
ASF GitHub Bot commented on EAGLE-85:
-------------------------------------
Github user haoch commented on a diff in the pull request:
https://github.com/apache/incubator-eagle/pull/27#discussion_r47482020
--- Diff:
eagle-security/eagle-security-hive/src/test/java/org/apache/eagle/security/hive/ql/TestParser.java
---
@@ -248,9 +249,11 @@ public void testDropTable() throws Exception {
_testParsingQuery(query, expectedOperation, null, null);
}
+ @Ignore
@Test
public void testUnionAll() throws Exception {
- String query = "INSERT OVERWRITE TABLE be_view_event_user_t1_miss
PARTITION ( dt='20151125', hour='06') select a.uid ,a.site_id ,a.page_id
,a.curprice ,a.itm ,a.itmcond ,a.itmtitle ,a.l1 ,a.l2 ,a.leaf ,a.meta ,a.st
,a.dc ,a.tr ,a.eventtimestamp ,a.cln ,a.siid ,a.ciid ,a.sellerid ,a.pri from
(select a1.* from (select * from soj_view_event where dt='20151125' and
hour='06') a1 inner join (select uid from soj_viewitem_event_uid_sample where
dt='20151125' and hour='06') b1 on a1.uid = b1.uid) a left outer join (select
c.* from (select * from be_viewitem_event_user_t1 where dt='20151125' and
hour='06') a2 lateral view json_tuple(a2.values, 'u', 'site_id', 'p',
'current_price', 'item_id', 'item_condition', 'item_title', 'l1_cat_id',
'l2_cat_id', 'leaf_cat_id', 'meta_cat_id','sale_type_enum',
'shipping_country_id', 'time_remain_secs', 'timestamp', 'collection_id',
'source_impression_id', 'current_impression_id', 'sellerid' ) c as uid,
site_id, page_id, curprice, itm, itmcond, itmtitle, l1, l2, leaf, meta, st, dc,
tr, eventtimestamp, cln, siid, ciid, sellerid ) b on a.uid = b.uid and
a.site_id = b.site_id and a.page_id = b.page_id and coalesce(a.curprice,
'null') = coalesce(b.curprice, 'null') and coalesce(a.itm, 'null') =
coalesce(b.itm, 'null') and coalesce(a.itmcond, 'null') = coalesce(b.itmcond,
'null') and coalesce(trim(reflect(\"java.net.URLDecoder\",
\"decode\",regexp_replace(a.itmtitle,\"\\\\+\",\" \"),\"utf-8\")),'null') =
coalesce(trim(b.itmtitle),'null') and coalesce(a.l1, 'null') = coalesce(b.l1,
'null') and coalesce(a.l2,'null') = coalesce(b.l2,'null') and
coalesce(a.leaf,'null') = coalesce(b.leaf,'null') and coalesce(a.meta,'null') =
coalesce(b.meta,'null') and coalesce(a.st,'null') = coalesce(b.st,'null') and
coalesce(a.dc,'null') = coalesce(b.dc,'null') and
coalesce(reflect(\"java.net.URLDecoder\", \"decode\",a.tr,\"utf-8\"),'null') =
coalesce(b.tr,'null') and a.eventtimestamp = b.eventtimestamp and
coalesce(a.cln,'null') = coalesce(b.cln,'null') and coalesce(a.siid,'null') =
coalesce(b.siid,'null') and coalesce(a.ciid,'null') = coalesce(b.ciid,'null')
and coalesce(a.sellerid, 'null') = coalesce(b.sellerid, 'null') where b.uid is
null distribute by a.uid sort by a.uid , a.eventtimestamp";
+ String query = "INSERT OVERWRITE TABLE be_view_event_user_t1_miss
PARTITION ( dt='20151125', hour='06') select a.uid ,a.site_id ,a.page_id
,a.curprice ,a.itm ,a.itmcond ,a.itmtitle ,a.l1 ,a.l2 ,a.leaf ,a.meta ,a.st
,a.dc ,a.tr ,a.eventtimestamp ,a.cln ,a.siid ,a.ciid ,a.sellerid ,a.pri from
(select a1.* from (select * from soj_view_event where dt='20151125' and
hour='06') a1 inner join (select uid from soj_viewitem_event_uid_sample where
dt='20151125' and hour='06') b1 on a1.uid = b1.uid) a left outer join (select
c.* from (select * from be_viewitem_event_user_t1 where dt='20151125' and
hour='06') a2 lateral view json_tuple(a2.values2, 'u', 'site_id', 'p',
'current_price', 'item_id', 'item_condition', 'item_title', 'l1_cat_id',
'l2_cat_id', 'leaf_cat_id', 'meta_cat_id','sale_type_enum',
'shipping_country_id', 'time_remain_secs', 'timestamp', 'collection_id',
'source_impression_id', 'current_impression_id', 'sellerid' ) c as uid,
site_id, page_id, curprice, itm, itmcond, itmtitle, l1, l2, leaf, meta, st, dc,
tr, eventtimestamp, cln, siid, ciid, sellerid ) b on a.uid = b.uid and
a.site_id = b.site_id and a.page_id = b.page_id and coalesce(a.curprice,
'null') = coalesce(b.curprice, 'null') and coalesce(a.itm, 'null') =
coalesce(b.itm, 'null') and coalesce(a.itmcond, 'null') = coalesce(b.itmcond,
'null') and coalesce(trim(reflect(\"java.net.URLDecoder\",
\"decode\",regexp_replace(a.itmtitle,\"\\\\+\",\" \"),\"utf-8\")),'null') =
coalesce(trim(b.itmtitle),'null') and coalesce(a.l1, 'null') = coalesce(b.l1,
'null') and coalesce(a.l2,'null') = coalesce(b.l2,'null') and
coalesce(a.leaf,'null') = coalesce(b.leaf,'null') and coalesce(a.meta,'null') =
coalesce(b.meta,'null') and coalesce(a.st,'null') = coalesce(b.st,'null') and
coalesce(a.dc,'null') = coalesce(b.dc,'null') and
coalesce(reflect(\"java.net.URLDecoder\", \"decode\",a.tr,\"utf-8\"),'null') =
coalesce(b.tr,'null') and a.eventtimestamp = b.eventtimestamp and
coalesce(a.cln,'null') = coalesce(b.cln,'null') and coalesce(a.siid,'null') =
coalesce(b.siid,'null') and coalesce(a.ciid,'null') = coalesce(b.ciid,'null')
and coalesce(a.sellerid, 'null') = coalesce(b.sellerid, 'null') where b.uid is
null distribute by a.uid sort by a.uid , a.eventtimestamp";
--- End diff --
Remove the sensitive table name
> Fix unit test failure.
> ----------------------
>
> Key: EAGLE-85
> URL: https://issues.apache.org/jira/browse/EAGLE-85
> Project: Eagle
> Issue Type: Bug
> Affects Versions: 0.3.0
> Reporter: Su Ralph
> Assignee: Su Ralph
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
