[ 
https://issues.apache.org/jira/browse/OOZIE-1741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13933032#comment-13933032
 ] 

Satish Mittal commented on OOZIE-1741:
--------------------------------------

As an example, suppose the Hive QL contains the following statement:

export table $ {sourceDatabase}.$ {sourceTable} partition $ {sourcePartition} 
to '$ {sourceStagingDir}';

where the value of $ { sourcePartition} is populated by $ 
{coord:dataInPartitionFilter('input', 'hive')}. The sample output of partition 
value looks like: (minute='00' AND month='03' AND year='2014' AND hour='09' AND 
day='11'). 

The resulting Hive job fails with the following error:
FAILED: ParseException line 1:51 mismatched input 'AND' expecting ) near ''00'' 
in export statement


> Add new coord EL function to get partition value string
> -------------------------------------------------------
>
>                 Key: OOZIE-1741
>                 URL: https://issues.apache.org/jira/browse/OOZIE-1741
>             Project: Oozie
>          Issue Type: Improvement
>            Reporter: Satish Mittal
>            Assignee: Satish Mittal
>
> Currently oozie provides coord EL functions to get partition filter string 
> (where key-values are separated by AND)  for various action types - 
> java/pig/hive. However this doesn't work in other cases, e.g. hive action 
> that performs export/import of hive partition. In that case, the partition 
> value is expected to be in a different format: 
> (col1="value1",col2="value2"...). We need to add a new EL function that 
> returns partition value in the above format.



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

Reply via email to