Execute the statement, tell me mistake,
Hive> The ALTER TABLE t_hive ADD COLUMNS (new_col String);

FAILED: Execution Error, the return code from 1 org.. Apache hadoop. Hive. Ql. Exec. DDLTask. Unable to alter table. For direct MetaStore DB connections, we don 't support retries at the client level.

Can't insert a new field, the original table structure
Hive> Desc t_hive;
OK
A int
Int b
C int

CodePudding user response:

The Log error message

The 2017-05-19 14:53:41, 036 ERROR [main] : ql. The Driver (SessionState. Java: printError (960) - FAILED: Execution ERROR, the return code from 1 org.. Apache hadoop. Hive. Ql. Exec. DDLTask. Unable to alter table. For direct MetaStore DB connections, we don 't support retries at the client level.
The 2017-05-19 14:53:41, 036 INFO [main] : the metadata. The Hive (Hive. Java: logDumpPhase (3294)) - Dumping metastore API call timing information for: execution phase
The 2017-05-19 14:53:41, 037 INFO [main] : the metadata. The Hive (Hive. Java: dumpAndClearMetaCallTiming (3285) - the Total time spent in this metastore function was greater than 1000 ms: getTable_ (String, String,)=2108
The 2017-05-19 14:53:41, 037 INFO [the main] : the PerfLogger (PerfLogger. Java: PerfLogEnd (148)) - & lt;/PERFLOG method=Driver. The execute start=1495176797529 end=1495176821037 duration=23508 from=org). Apache hadoop. Hive. Ql. Driver>
The 2017-05-19 14:53:41, 037 INFO [the main] : the PerfLogger (PerfLogger. Java: PerfLogBegin (121)) - & lt; PERFLOG method=releaseLocks from=org, apache hadoop. Hive. Ql. Driver>
The 2017-05-19 14:53:41, 037 INFO [the main] : the PerfLogger (PerfLogger. Java: PerfLogEnd (148)) - & lt;/PERFLOG method=releaseLocks start=1495176821037 end=1495176821037 duration=0 from=org.. Apache hadoop. Hive. Ql. Driver>
The 2017-05-19 14:53:41, 037 INFO [the main] : the PerfLogger (PerfLogger. Java: PerfLogBegin (121)) - & lt; PERFLOG method=releaseLocks from=org, apache hadoop. Hive. Ql. Driver>
The 2017-05-19 14:53:41, 037 INFO [the main] : the PerfLogger (PerfLogger. Java: PerfLogEnd (148)) - & lt;/PERFLOG method=releaseLocks start=1495176821037 end=1495176821037 duration=0 from=org.. Apache hadoop. Hive. Ql. Driver>