You'll need to look through the Region Server log files to find the root cause of the problem. The error message you shared is not enough information to go on. ... View more

Can you show the first couple lines of your file exactly as they appear in the file. You can open the CSV with a simple text editor of your choice and show the output in a comment here.    When you are in the upload screen in Hue, note that under Extras section there are additional parameters that you might need to adjust to fit your file formatting. ... View more

I was able to reproduce this error and it looks like the problem is the identical column name in your tableA and tableB. Namely, DateColumn is referenced in the subquery. Hive interprets this as a reference to the parent query which is not allowed (per limitation listed here). Essentially it's confused what you mean by this query due to overloaded column name.   To solve this, you can explicitly specify table names when referring to columns: UPDATE tableA SET tableA.ColA = "Value" WHERE year(tableA.DateColumn) >= ( select (max(year(tableB.DateColumn))-1) from tableB )   Let me know if this works. Regards, Alex ... View more

This could be a good start: https://community.cloudera.com/t5/Support-Questions/Using-NiFi-to-load-data-from-localFS-to-HDFS/td-p/212124   ... View more

You also want to check the structure of your raw data. Specifically, look for any instances where there are extra delimiters (e.g. a string field that includes commas as part of the string).  ... View more