Problem Description:


Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.io.Text cannot be cast to org.apache.hadoop.io.BytesWritable




TROUBLESHOOTING STEPS:


1)Download the python script in below attchment and move that to the Infoworks edge node.


2)Navigate to 

$IW_HOME/bin and run source env.sh


3)Run:

python update_table_cols.py <table_id> <col_name>

pass the particular table id and column name.


4)Run initialize and ingest.