topic Re: Storing Data from Kafka Input in smaller files in Talend Studio

Storing Data from Kafka Input in smaller files

Anonymous — Sat, 16 Nov 2024 09:42:06 GMT

Hi,

In my usecase, i am receiving data in Kafka 24*7 in ebcdic. I read the data as byte array from kafkainput and parse the data using the tHMAP. Output of tHmap goes to tjavarow as byte array. output from the tJavaRow is getting stored in tHDFSOutput. Initial tJava component to create the filename with datetimestamp.

Here are my challenges

1) my data is getting stored as a single file in hdfs. I need to have them smaller file, as i might need to see the data from morning to afternoon (or to any point of time). Because of me having the data in a single file, i am unable to fetch data.

2) I tried updating the filename in the tJavaRow (that is the reason for inserting the component here). But i am unable to change the file name.

Need some suggestions to get this done.

Below is a flow, recreated for understanding.

Re: Storing Data from Kafka Input in smaller files

vapukov — Thu, 01 Jun 2017 23:13:13 GMT

just the question, if reason for split only access to timed data - why not query over HDFS files?

- SQL

- Hive

- Drill

Re: Storing Data from Kafka Input in smaller files

Anonymous — Fri, 02 Jun 2017 05:05:54 GMT

For a day, i am expecting around 100GB data to be received. So, i am storing the data in HDFS with partition. But, the file initially created only being used to store the data despite the partition on date created on run time in tjavarow component.

Re: Storing Data from Kafka Input in smaller files

Anonymous — Wed, 07 Jun 2017 11:56:58 GMT

any suggestions ?

Re: Storing Data from Kafka Input in smaller files

vapukov — Wed, 07 Jun 2017 12:49:30 GMT

Looking on Your original screenshot - You have something wrong in 2 components

Not for HDFS, but it work like this:

You must define variable before component start work, in my case - tJavaFlex3, an result will be: