Select Into - Redshift

Question

Does select * into table query work in Redshift? I get the following error when I try it:

JDBC Driver]com.amazon.dsi.dataengine.impl.DSISimpleRowCountResult cannot be cast to com.amazon.dsi.dataengine.interfaces.IResultSet [SQL State=HY000] 1 statement failed.

Answer 1

Select * into in Redshift very well work. Please refer the URL

The error you have mentioned is because of the Driver issue in the sqlworkbench. Please refer the url to set the driver. Test whether your select * from table is working fine