Hello   I am not sure the data in your Hive table got duplicates? Maybe try SELECT DISTINCT? ... View more

I already tried it  11:35:11 CEST ERROR SelectHiveQL[id=0ccbb0ab-fcf7-3037-e2c0-0ea5f7799f7c] Unable to execute HiveQL select query SELECT * FROM global_2g; due to org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not establish connection to jdbc:hive2://173.249.11.251:10000/tables;: Required field 'serverProtocolVersion' is unset! Struct:TOpenSessionResp(status:TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Failed to open new session: java.lang.RuntimeException:   ... View more

For future reference adding here the link to our public documentation on how to connect NiFi with Hive on CDP. ... View more

I'm using pyspark and I'm using hadoop 2.7.7 and not I'm not using llap   ... View more

Thank you for your reply  I don't want to use spark warehouse, I want to use hive warehouse the global hive  ... View more

most file formats can be extracted via tika   https://community.cloudera.com/t5/Community-Articles/ExtractText-NiFi-Custom-Processor-Powered-by-Apache-Tika/ta-p/249392 ... View more

Lookup the proper java regex you need   https://examples.javacodegeeks.com/core-java/util/regex/list-files-with-regular-expression-filtering/   https://www.freeformatter.com/java-regex-tester.html   https://regexr.com/   ... View more