HBase version : 1.2.6 Phoenix version : 4.10.0-HBase-1.2.6 I am trying to create new table by using the already existing table but I don't know how to do it ?? I have tried like:
CREATE TABLE "+targerSchemaName+"."+targetTableName+" AS SELECT * FROM "+schemaName+"."+tableName and also i tried like: CREATE TABLE "+targerSchemaName+"."+targetTableName+" Like SELECT * FROM "+schemaName+"."+tableName But getting error. So how to create new table based on existing table in same or different schema ?? Please help me.