复制表结构和数据： create table new_table as select * from exists_table; 结构报错了

Question

复制表结构和数据： create table new_table as select * from exists_table;  结构报错了

 

NoViableAltException(27@[799:1: ddlStatement : ( createDatabaseStatement | switchDatabaseStatement | dropDatabaseStatement | createTableStatement | dropTableStatement | truncateTableStatement | alterStatement | descStatement | showStatement | metastoreCheck | createViewStatement | dropViewStatement | createFunctionStatement | createMacroStatement | createIndexStatement | dropIndexStatement | dropFunctionStatement | reloadFunctionStatement | dropMacroStatement | analyzeStatement | lockStatement | unlockStatement | lockDatabase | unlockDatabase | createRoleStatement | dropRoleStatement | ( grantPrivileges )=> grantPrivileges | ( revokePrivileges )=> revokePrivileges | showGrants | showRoleGrants | showRolePrincipals | showRoles | grantRole | revokeRole | setRole | showCurrentRole | abortTransactionStatement );])
    at org.antlr.runtime.DFA.noViableAlt(DFA.java:158)
    at org.antlr.runtime.DFA.predict(DFA.java:144)
    at org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:3061)
    at org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:2266)
    at org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1318)
    at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:218)
    at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:75)
    at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:68)
    at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:564)
    at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1425)
    at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1493)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1339)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1328)
    at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239)
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:409)
    at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:836)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:772)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:699)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 

Answer 1

hive 的问题 NoViableAltException 应该是你调用的时候参数有问题了，或者执行的语句不对

Answer 2

create table if not exists table3
LIKE table1 ;   这种方法是可以的