I was trying to create a baseview in denodo by using the below query. i am getting an exception
com.denodo.util.exceptions.InternalErrorException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.35] [Error 1077] [SQLState HY000] executeQuery() cannot be used when there is no result set expected; use executeUpdate() or execute()
create volatile table xyz
(outlet_id, Outlet_name, Address, SubCat_code) as
addr,subcategory_code from table1)
with data primary index (outlet_id, SubCat_code) ON COMMIT PRESERVE ROWS;
Please let me know if anyone has tried and come across the issue.