question Re: Get DATA from hive using apache nifi in Support Questions

question Re: Get DATA from hive using apache nifi in Support Questions https://community.cloudera.com/t5/Support-Questions/Get-DATA-from-hive-using-apache-nifi/m-p/313838#M225755 Hello Try to set the "Database User", e.g. hive If you refer to the Hive2 JDBC documentation, the user ID is required <A href="https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-UsingJDBC" target="_blank" rel="noopener">https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-UsingJDBC</A> The default <port> is 10000. In non-secure configurations, specify a <user> for the query to run as. The <password> field value is ignored in non-secure mode.<DIV class="preformatted panel conf-macro output-block"><DIV class="preformattedContent panelContent"><PRE>Connection cnct = DriverManager.getConnection("jdbc:hive2://<host>:<port>", "<user>", "");</PRE></DIV></DIV> Tue, 30 Mar 2021 09:19:16 GMT Daming Xue 2021-03-30T09:19:16Z