I cannot get the following query run using PutHiveQL processor, it fails with the permission denied exception. I see that the processor emulates the same behavior as in Beeline. But, I have been able to run the query from Hive CLI and writes to a file as expected. So, we know that Hive shell is an option, but can you let me know if there is any specific settings that causes this behavior in Beeline (Hive2) preventing to write to local filesystem? insert overwrite local directory '/tmp' select current_date from dual Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [xxxxx] does not have [WRITE] privilege on [/tmp] (state=42000,code=40000) ... View more

For a simple reflect function as below which works in HIVE shell, cannot be executed through PutHiveQL processor. Do you know if this is an expected behavior? SELECT reflect("java.util.UUID", "nameUUIDFromBytes", "test") from dual ... View more

I have a process group and from the input port, I just could not link to the ExecuteProcess processor. Can you please advise on any specific reason for that? ... View more

After querying from Hive, I wanted to write into a file with a custom delimiter say |, is there a way to achieve that? I cannot use Replacetext to replace, with the custom delimiter as the column values may have comma in it. One other option I see is have query producing single string with custom delimiter. But it encloses the column values with the double quotes for the string type columns and that voids the required fileformat. ... View more

How to achieve the following with inbuilt UDF in Hive? 1 35 2 22 3 45 4 64 To 1 2 3 4 35 22 45 64 ... View more

So, splitting to two separate processor with the same relationship "success" say from FetchFile processor, does the flowfile content gets replicated? It appears that it is true, as I observed the uuid values are different when compared between the two. Is it safe to assume the changes to flowfile content on one flow (even on one end it gets discarded) would not have any impact to the other? ... View more

I have an external table with the keyword timestamp as one of the column name. Unlike hive shell that provides option to turnoff keyword validation like below, is there a way to execute the SELECT query in the above processor? set hive.support.sql11.reserved.keywords=false; I get the following error if I try to execute the query through the SelectHiveQL processor Failed to recognize predicate 'timestamp'. Failed rule: 'identifier' in table or column identifier ... View more