Hello @shraddha srivastav, You seem to be using a slightly different dependency package. As per Zeppelin 0.7 doc (https://zeppelin.apache.org/docs/0.7.0/interpreter/jdbc.html#redshift) page, it is tested with dependency "com.amazonaws:aws-java-sdk-redshift:1.11.51". Would you mind following the doc and setting your property exactly as it is shown? Thanks, hope this helps!
... View more
@shraddha srivastav I apology for not been able to respond to your queries. I am not much familiar with the zeppelin graph customization/plotting. I will try to find the answer.
... View more
The above question and the entire reply thread below was originally posted in the Community Help Track. On Thu Jun 13 04:29 UTC 2019, a member of the HCC moderation staff moved it to the Data Science & Advanced Analytics track. The Community Help Track is intended for questions about using the HCC site itself.
... View more
Hi All, so I have a file coming in following format: {"Field_1":0.01,"abc_id":5,"pqr_id":"0","xyz_id":946715026,"items":130,"Epoch":"130723413","measurement":"milliohm/s"} {"Field_2":0.01,"abc_id":2,"pqr_id":"5","xyz_id":841712547,"items":190,"Epoch":"130723414","measurement":"meter/m5"} - - - - - .....and so forth I have multiples rows with attribute name: values. What processor to use to separate the attribute as fields/columns and parse its respective values. I want to parse the file in a way I can extract the field names and values separately as my ultimate goal is to feed the file data into MySQL(table schema in MySQL is defined Below:) Field_1, Field_2, abc_id,pqr_id,xyz_id,items,Epoch,measurement How can I achieve the whole use case in NiFi? I think I can achieve this using some kind of regular expression but I am not sure what regular expression will help me get the desired output. Any suggestion is much appreciated. Thanks!
... View more
so I have a file coming in following format: {"Field_1":0.01,"abc_id":5,"pqr_id":"0","xyz_id":946715026,"items":130,"Epoch":"130723413","measurement":"milliohm/s"} {"Field_2":0.01,"abc_id":2,"pqr_id":"5","xyz_id":841712547,"items":190,"Epoch":"130723414","measurement":"meter/m"} - - - - - .....and so forth I have multiples rows with attribute name: values. What processor to use to separate the attribute as fields/columns and parse its respective values. I want to parse the file in a way I can extract the field names and values separately as my ultimate goal is to feed the file data into MySQL(table schema in MySQL is defined Below:) Field_1, Field_2, abc_id,pqr_id,xyz_id,items,Epoch,measurement How can I achieve the whole use case in NiFi? I think I can achieve this using some kind of regular expression but I am not sure what regular expression will help me get the desired output. Any suggestion is much appreciated. Thanks!
... View more
@shraddha srivastav, Bit late but try this... ^[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,([^,]*),[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,([^,]*),[^,]*,[^,]*,([^,]*)\S*
... View more
@Shu Please find attached the list queue after GetFile. As soon as i start my UpdateRecord the List queue become blank. attaching the listqueue after UpdateRecord processor Expected output is to concatenate the row 9th value (FEBetaPack01) and 23rd row value (FE_ChargerSim_CurrentRipple)under column 'filename ' as (FEBetaPack01-FE_ChargerSim_CurrentRipple). Please help. Thanks
... View more
Duplicated question..!! Please refer to the original thread answer: https://community.hortonworks.com/questions/212355/extract-values-from-csv-and-place-it-in-a-new-colu-1.html
... View more
Hi @shraddha srivastav, Apperently you try to convert string field into the time stamp. on your record schema at the source end you shoud define the data type as long instead of string for EpochWithMicroSec under the fields secton {"name":"EpochWithMicroSec","type":{"type":"long","logicalType":"timestamp-millis"}} so that the conversion shall be able to perform from source to target. hope this helps!!
... View more
Hi Steven, How do i tail my nifi log to see the errors? What changes do i have to make in order to see the errors while building data flows?
... View more
