7.00.02 - AX Sanity Test does not create table - Aster Execution Engine

Aster Instance Installation Guide for Aster-on-Hadoop Only

prodname
Aster Execution Engine
vrm_release
7.00.02
created_date
July 2017
category
Installation
featnum
B700-5022-700K

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';