@Vinay R Glad it helped you. If you think it solves your problem then please accept the answer. ... View more

Hi @Atul Goel Could you please share the table DDL? ... View more

Hi @Ishvari Dhimmar As stated by Ervits after flattening the pig output to remove bags if there are any use the file to load into a hive table. For loading into a hive table use " load data inpath <pig out output file> into table <hive table name>". Ensure that the format of the pig output file is compatible with hive native formats. If you do so then you will achieve what you are looking for. ... View more

Hi @Raphaël MARY If you are using Greenplum then there is an existing protocol which will take care of your use case. gphdfs protocol. Its simple and easy but it will support only TEXT and CSV as of now. https://discuss.pivotal.io/hc/en-us/articles/202635496-How-to-access-HDFS-data-via-GPDB-external-table-with-gphdfs-protocol Check the above link for gphdfs protocol. ... View more

Hi @rajdip chaudhuri Update is supported only for hive table in which ACID property is enabled. Also by seeing your querying im afraid as I hive will not support such use case as of now. However once MERGE statement is added you will be able to update using join. Check on this Jira ticket . https://issues.apache.org/jira/browse/HIVE-10924 If you use your existing query it will fail. Alternatively load the data after performing join into a temp table and then update the target based on your temp table. ... View more

@Wynner Atlast !! Yeah!! Thanks a ton! ... View more

@Wynner Thanks. it seems the problem is im not running nifi as adminstrator. It solved my issue. Im able to start NiFi through cmd. But again one more problem begins. Attached the screenshot appreciate your help. ... View more

@Wynner When i try to run-Nifi in c drive it works fine. But If copy Nifi and its related file to d drive and run-Nifi from that that directory then it throws an error. ... View more