10-18-2017 07:09 PM
10-18-2017 07:44 PM
10-19-2017 07:32 AM
You are absolutely right! The fifth file 000004_0 in the parquet hive table directory had one string that matched the row value in the beeline SQL output. I am sure the other strings will also be in the data. So it finally confirms that everything is working fine without any errors in hive. Thanks for all your help as this really confused me but I did learn couple of new things so thanks again!!
$ parquet-tools cat 000004_0 | grep '(7256823 row(s) affected)'
triptype = (7256823 row(s) affected)