While running HCAT_SYNC_OBJECTS procedure in BigSQL it fails with following ERROR code

SQLSTATE=42601 ,SQLCODE=-104

The following stack trace and ERROR message is observed in bigsql.log file com.ibm.db2.jcc.am.SqlSyntaxErrorException: An unexpected token "name" was found following "emp.name as Employee".  Expected tokens may include:  "".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.22.29         at com.ibm.db2.jcc.am.ld.a(ld.java:810)         at com.ibm.db2.jcc.am.ld.a(ld.java:66)         at com.ibm.db2.jcc.am.ld.a(ld.java:140)         at com.ibm.db2.jcc.am.up.c(up.java:2796)         at com.ibm.db2.jcc.am.up.d(up.java:2784)         at com.ibm.db2.jcc.am.up.b(up.java:2146)         at com.ibm.db2.jcc.t4.bb.j(bb.java:233)         at com.ibm.db2.jcc.t4.bb.c(bb.java:48)         at com.ibm.db2.jcc.t4.p.b(p.java:38)         at com.ibm.db2.jcc.t4.vb.h(vb.java:124)         at com.ibm.db2.jcc.am.up.kb(up.java:2141)         at com.ibm.db2.jcc.am.up.a(up.java:3336)         at com.ibm.db2.jcc.am.up.c(up.java:768)         at com.ibm.db2.jcc.am.up.executeUpdate(up.java:747)         at com.ibm.biginsights.biga.udf.HCAT_SYNC_OBJECTS.synchronizeObject(HCAT_SYNC_OBJECTS.java:1782)         at com.ibm.biginsights.biga.udf.HCAT_SYNC_OBJECTS.synchronizeTable(HCAT_SYNC_OBJECTS.java:648)         at com.ibm.biginsights.biga.udf.HCAT_SYNC_OBJECTS.syncTables(HCAT_SYNC_OBJECTS.java:564)         at com.ibm.biginsights.biga.udf.HCAT_SYNC_OBJECTS.exec(HCAT_SYNC_OBJECTS.java:314)

The hive view object has a column name with whitespace characters. Hive supports column name with space

BigSQL 5.0.x

BigSQL currently does not support column name with spaces, hence rename the hive columns and use non-whitespace characters