I have joined two tables and fetched data using Postgres source connector. But every time it gave the same issue i.e. 
I have run the same query in Postgres and it runs without any issue. Is fetching data by joining tables not possible in Kafka?
Can't we join two tables and fetch data in Kafka?
492 views Asked by Sajita At
1
There are 1 answers
Related Questions in APACHE-KAFKA
- No method found for class java.lang.String in Kafka
- How to create beans of the same class for multiple template parameters in Spring
- Troubleshoot .readStream function not working in kafka-spark streaming (pyspark in colab notebook)
- Handling and ignore UNKNOWN_TOPIC_OR_PARTITION error in Kafka Streams
- Connect Apache Flink with Apache kudu as sink using Pyflink
- Embedded Kafka Failed to Start After Spring Starter Parent Version 3.1.10
- Producer Batching Service Bus Vs Kafka
- How to create a docker composer environment where containers can communicate each other?
- Springboot Kafka Consumer unable to maintain connect to kafka cluster brokers
- Kafka integration between two micro service which can respond back to the same function initiated the request
- Configuring Apache Spark's MemoryStream to simulate Kafka stream
- Opentelemetry Surpresses Kafka Produce Message Java
- Kafka: java.lang.NoClassDefFoundError: Could not initialize class org.apache.logging.log4j.core.appender.mom.kafka.KafkaManager
- MassTransit Kafka producers configure to send several events to the same Kafka topic
- NoClassDefFoundError when running JAR file with Apache Kafka dependencies
Related Questions in APACHE-KAFKA-STREAMS
- Handling and ignore UNKNOWN_TOPIC_OR_PARTITION error in Kafka Streams
- spring-cloud-stream-binder-kafka-streams consumer shuts down when RuntimeException occurs
- Is there a way to sync applications having kafka stream to avoid duplicate message processing?
- Kafka Streams: Efficient Batch Collection and State Store Management
- Springboot kafka consumer dies permanently
- Understanding the requirements for a Kafka streams application
- Kafka Streams topology initially dropping messages to intermediate topics
- "ConfigException: Please specify a key serde or set one" although I've specified it and also set a default one in my Spring Boot + Kafka Stream app
- Kafka Streams: Kafka Stream Application getting intermittent SaslAuthenticationException
- Switch between Kafka topics
- How to insert a time/data filtered Kafka Stream into a Postgres Database
- Calling POST Rest API in kafka streams application
- Using TopologyTestDriver for testing Biconsumer
- Filtering and forwarding Kafka messages based on key alone with Kafka Streams
- How to write BatchProcessor for lambda with Kafka trigger in AWS?
Related Questions in APACHE-KAFKA-CONNECT
- Transform Load pipeline for a logs system: Apache Airflow or Kafka Connect?
- Kafka Connect JDBC Connector not working with teradata
- How can I change index name that created by kafka-connect with connect config
- Advantages of using two Kafka Connect Sink connectors for topics with similar data and workload?
- Neo4j Source Connectors Failing to build the Schema where the source query returns null for some of the fields
- kafka connect to minio
- MANAGE LIFECYCLE OF VAULT SECRET WITH CUSTOM ["org.apache.kafka.common.config.provider"]
- Debezium sink connector doesn't delele rows in destination postgres
- Is it possible to drop a field that it's value is null from a kafka event in kafka connector?
- MSK Connector w/ SMT
- How to make one reroute for all topics in debezium Kafka Connect PostgresConnector
- Kafka Connect JDBC Sink Connector giving WorkerSinkTask ERROR: JsonConverter with schemas.enable requires "schema" and "payload"
- JAAS configuration for Managed Identity for Kafka-Connect in Azure
- Current parse Mode: FAILFAST. To process malformed records as null result, try setting the option 'mode' as 'PERMISSIVE'
- Kafka Connect - Redis Sink Connector doing String upsert with last consumed message offset
Related Questions in KAFKA-JOIN
- KStream join with KTable record drops if key not exist in KTable
- Tombstone records not processed in Kstream-Ktable join
- Kafka streams join duplicates
- How to use Kafka Streams to only process messages sent less than 3 times per key (UserId) over a given time window
- How to implement KStream-Ktable leftJoin, how to get and set the field by using Envelope object and implement the join for KStream-Ktable?
- Relative amount of events in kafka streams using join
- What is the best approach to merge two events from same topic using Kafka Streams Api?
- Kafka streams join: How to wait a duration of time before emitting records?
- Kstream-Kstream join based on common field
- Kafka- join KStream and KTable on composite key
- Does KTable and KStream join publish a new record when there's an update on KTable?
- Can't we join two tables and fetch data in Kafka?
- how to handle one to many relationship using kafka streams join operations
- Kafka - Joining Data from two different Streams when Data comes at different times
- Kafka KStream to KStream join | restart performance
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I solve this issue by using the concept of the subquery. The problem was that
when I use an alias, the alias column is interpreted as a whole as a column name and therefore the problem occurs. Here goes my query:
select * from (select p.\"Id\" as \"p_Id\", p.\"CreatedDate\" as p_createddate, p.\"ClassId\" as p_classid, c.\"Id\" as c_id, c.\"CreatedDate\" as c_createddate, c.\"ClassId\" as c_classid from \"PolicyIssuance\" p left join \"ClassDetails\" c on p.\"DocumentNumber\" = c.\"DocumentNo\") as result"