#13876: Alter Table window doesn't open for Table having TableName as reserved keyword

anilkalshetti reported 2015-11-20T07:25:31Z · last modified 2017-05-18T21:44:09Z

Alter Table window doesn't open for Table having TableName as reserved keyword

Dev	tomconrad
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	Hive
Version	19.0

Aqua Data Studio 17.0.0-rc-39
Build #: 47130
Built on: 2015-Nov-19 03:07:33 PM

OS: Ubuntu 14.04
Linux (3.13.0-59-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=578,813,952; Free=226,655,184; CPUs=8

Database: MapR 5.0 Hive 1.0.0

Driver: Hive 1.0.0 Download link

Issue: Alter Table window doesn't open for Table having TableName as reserved keyword

Steps:

1. Create table using below script. Or use ADS Visual Editor-Create Table

CREATE TABLE `TABLESAMPLE` (

`col1` string,

`col2` string,

`col3` string,

`col4` string)

ROW FORMAT DELIMITED

STORED AS TEXTFILE

2. Here Table Name - TABLESAMPLE is reserved keyword.
We are able to create table with this name from ADS Visual Editor-Create Table.

3. Table is created. Right click on the table
a] select option-> Alter Table

Alter Table window doesn't open. <-- Issue

b] select option-> Script Object To Windows As -> Select / Insert / Create
Script is not generated. <-- Issue

@Dev:

- Hive has too many reserved keywords - Link
- Backtick quotation will enables the use of reserved keywords for table and column identifiers.

5 attachments

TestedInADS18.png

2016-10-07T06:09:03Z

96 KB
exception.png

2016-10-07T06:09:03Z

97 KB
13876_scripts.png

2017-04-25T09:50:38Z

144 KB
13876_altertable.png

2017-04-25T09:50:38Z

119 KB
SparkSQL_Alter.png

2017-04-25T09:50:38Z

113 KB

All Comments (6) Change History

dutondeumesh 2016-10-07T06:01:22Z

Take simple example, Execute below script in Query analyzer

CREATE TABLE `select` (x INT)

Here select is reserved keyword , since it is with backticks query succeeds.

But in ADS, go to table select , try to expand the column in tree node you will observed exception.

Exception :

org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:19 extraneous input 'select' expecting EOF near '<EOF>'

at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:235)

at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:221)

at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:244)

at com.aquafold.aquacore.open.rdbms.drivers.hive.eꁩ⡜ꐢꂞ10synchronized.execute(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.iꑷꎹ̞ꍤbyte.execute(Unknown Source)

at com.common.ui.tree.lᜥ⡊᠒ꊼprotectedBoolean.bWj(Unknown Source)

at com.common.ui.tree.lᜥ⡊᠒ꊼprotectedBoolean$1.process(Unknown Source)

at com.common.ui.util.BackgroundThread.run(Unknown Source)

Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:19 extraneous input 'select' expecting EOF near '<EOF>'

at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:374)

at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:136)

at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:206)

at org.apache.hive.service.cli.operation.Operation.run(Operation.java:316)

at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:425)

at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:401)

at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)

at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)

at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAs(Subject.java:415)

at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1693)

at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)

at com.sun.proxy.$Proxy27.executeStatementAsync(Unknown Source)

at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:258)

at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:506)

at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)

at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)

at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)

at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)

at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)

at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.lang.RuntimeException: org.apache.hadoop.hive.ql.parse.ParseException:line 1:19 extraneous input 'select' expecting EOF near '<EOF>'

at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:212)

at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)

at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:423)

at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:311)

at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1194)

at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1181)

at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:134)

... 26 more

Take simple example, Execute below script in Query analyzer

CREATE TABLE `select` (x INT)