Issue: BH-11195
Details: The AX Sanity Test tool fails to create a table inside the script setuphive.sh when it calls this command:
sudo -u hive hive -f hcat.sql
The failure to create a table is due to this hcat.sql code:
drop table if exists student_nonpart_text; create table student_nonpart_text( name string, age int, gpa double) row format delimited fields terminated by '\t' stored as textfile location '/sanitytest/student_nonpart_text';
Workaround: Update hcat.sql to:
create external table student_nonpart_text( name string, age int, gpa double) row format delimited fields terminated by '\t' stored as textfile location '/sanitytest/student_nonpart_text/student';