Member since
12-03-2017
122
Posts
12
Kudos Received
10
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1063 | 12-12-2022 09:16 PM | |
449 | 07-14-2022 03:25 AM | |
878 | 07-28-2021 04:42 AM | |
1133 | 06-23-2020 10:08 PM | |
6757 | 06-17-2020 11:43 PM |
07-29-2023
11:17 AM
Hello Experts, I am connecting Spark Thrift Server from Nifi through JDBC to run sql select query against delta tables. Normal select query is working fine. But now I want to implement pagination for my sql query for large tables. I tried using OFFSET and LIMIT x,y keywords etc but both of them did not work with STS JDBC. Is there anyway to achieve pagination with thrift server jdbc sql? I am not sure if offset and/or limit keywords are not available or not working due to some version. Could you please suggest me on this? Thanks Mahendra
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache NiFi
-
Apache Spark
07-18-2023
09:25 PM
Hello experts, We have setup our nifi to consume message from kafka broker which has SSL as security protocol. It worked well with pre-prod brokers, but facing below error in prod broker. (we have configured ssl context service with respective ssl certs) Preprod nifi <-> Preprod kafka : working Prod nifi <-> Prod kafka : Not working telnet is working from Prod nifi to Prod kafka broker. 2023-07-17 15:30:58,814 WARN [Timer-Driven Process Thread-190] org.apache.kafka.clients.NetworkClient [Consumer clientId=consumer-ProdOnHandR3NiFiConsumer-28, groupId=ProdOnHandR3NiFiConsumer] Connection to node -3 (kafka3.xxx.pivotal.emea.kaas.3stripes.net/xxx.128.xx.150:9093) terminated during authentication. This may happen due to any of the following reasons: (1) Authentication failed due to invalid credentials with brokers older than 1.0.0, (2) Firewall blocking Kafka TLS traffic (eg it may only allow HTTPS traffic), (3) Transient network issue. 2023-07-17 15:30:58,814 WARN [Timer-Driven Process Thread-190] org.apache.kafka.clients.NetworkClient [Consumer clientId=consumer-ProdOnHandR3NiFiConsumer-28, groupId=ProdOnHandR3NiFiConsumer] Bootstrap broker kafka3.xxx.pivotal.emea.kaas.3stripes.net:9093 (id: -3 rack: null) disconnected 2023-07-17 15:30:59,816 WARN [Timer-Driven Process Thread-104] org.apache.kafka.clients.NetworkClient [Consumer clientId=consumer-ProdSpmSeasonNiFiConsumer-26, groupId=ProdSpmSeasonNiFiConsumer] Connection to node -8 (kafka8.xxx.pivotal.emea.kaas.3stripes.net/xx.xxx.5.199:9093) terminated during authentication. This may happen due to any of the following reasons: (1) Authentication failed due to invalid credentials with brokers older than 1.0.0, (2) Firewall blocking Kafka TLS traffic (eg it may only allow HTTPS traffic), (3) Transient network issue. 2023-07-17 15:30:59,816 WARN [Timer-Driven Process Thread-104] org.apache.kafka.clients.NetworkClient [Consumer clientId=consumer-ProdSpmSeasonNiFiConsumer-26, groupId=ProdSpmSeasonNiFiConsumer] Bootstrap broker kafka8.xxx.pivotal.emea.kaas.3stripes.net:9093 (id: -8 rack: null) disconnected 2023-07-17 15:31:00,819 WARN [Timer-Driven Process Thread-127] org.apache.kafka.clients.NetworkClient [Consumer clientId=consumer-ProdSpmModelNiFiConsumer-25, groupId=ProdSpmModelNiFiConsumer] Connection to node -6 (kafka6.xxx.pivotal.emea.kaas.3stripes.net/xxx.128.xx.13:9093) terminated during authentication. This may happen due to any of the following reasons: (1) Authentication failed due to invalid credentials with brokers older than 1.0.0, (2) Firewall blocking Kafka TLS traffic (eg it may only allow HTTPS traffic), (3) Transient network issue. Any idea what could be the reason for this? Thanks Mahendra
... View more
Labels:
- Labels:
-
Apache Kafka
-
Apache NiFi
07-18-2023
08:46 PM
Old version of Databricks jdbc jar has the simba driver class, with that I am able to use jdbc:spark:// connection string. But jdbc:hive2:// performance looks better with thrift for me
... View more
07-16-2023
09:48 PM
Hello Experts, I need to query delta table from apache nifi. Since Nifi cant connect delta table directly, I am trying it through Spark Thrift Server. I have used 'Hive3ConnectionPool' controller service with 'SelectHive3QL' processor and used below jdbc url and it worked for me. jdbc:hive2://localhost:10002 But I dont know whether using jdbc:hive2//<host>:<port> is right approach or should I use jdbc:spark//<host>:<port> url? Will there be any performance difference between jdbc:hive2 & jdbc:spark jdbc url's with respect to performance or any other imp thing? I tried jdbc:spark//<host>:<port> url with ' DBCPConnectionPool 1.16.3 ' cntroller service but could not succeed with DatabricksJDBC jar. Any suggestion would be appreciated Thanks Mahendra
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache NiFi
-
Apache Spark
07-16-2023
09:37 PM
@MattWho Its very clear now, thank you so much !
... View more
07-10-2023
11:10 AM
Hello experts, One of our client has data stored in delta table(delta lake), I am totally new to delta lake part. Do we have any option in nifi to read data from delta lake or is there any sample 3rd party implementation available for the same for nifi? Thanks, Mahendra
... View more
Labels:
- Labels:
-
Apache NiFi
07-10-2023
11:00 AM
Hello Experts, I am using ConsumeAzureEventHub processor to consume messages in Nifi 1.16. ' Concurrent Tasks ' field of this processor is disabled so I am not able to speed up the consume processor. What is the reason for this limitation and is there any work around for this ? (we usually run kafka consumer with higher concurrency matching partitions) Thanks, Mahendra
... View more
Labels:
- Labels:
-
Apache NiFi
07-07-2023
09:18 AM
@MattWho Thank you so much for this awesome detailed solution ! It worked.
... View more
07-06-2023
10:56 AM
Hello experts, I need to connect to my customer's kafka broker from apache nifi processors. They said security protocol is SASL_SSL (where is SASL is PLAIN) and provided username and password for SASL part. But they say they dont have any ssl certificate to share for _SSL, they informed they are using clnfluent cloud and that does not need ssl certs to connect. But when I configure nifi processor with SASL_SSL it mandatorily asks for ssl certificate. Any idea how can I get this ssl certificate to connect to confluent cloud kafka broker ? Or how Nifi can connect without ssl ? Any suggestion/help much appreciated Thanks Mahendra
... View more
Labels:
- Labels:
-
Apache Kafka
-
Apache NiFi
01-31-2023
10:48 PM
Hello Experts, We have a nifi instance with 8 core machine, and recently nifi is looking quite slow with its performance (nifi-api response, UI etc). Recently we have added lot of processors but at any point of time the processor which are processing data will be only 10% of total processors. Will nifi perf goes down with increase in number of processors though 90% total processors will be idle? Thanks Mahendra
... View more
Labels:
- Labels:
-
Apache NiFi