Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
|
|
96 KB
|
|
319 KB
This will get retrofitted in V14 as soon as I retrofit 12118.
Build: ADS 15.0.0-dev-366
@Tom,
Hi,
Please try below things on Cloudera CDH5.0.2 VM, Hive Query Editor, ADS behaves differently than query editor.
1. Hive allow user to create database with database name starting with _ character.
Error : error while compiling statement: failed: parseexception line 1:4 cannot recognize input near '_a' '' '' in switch database statement
//Please refer screenshot: CDH502-dev-366.png
3. In ADS creating table in _a database is allowed, it shows success message. This ADS behaviour is contradictory to Hive Query Editor, Please let me know your opinion on this.
Build: ADS 15.0.0-dev-366
@Tom,
Hi,
Please try below things on Cloudera CDH5.0.2 VM, Hive Query Editor, ADS behaves differently than query editor.
1. Hive allow user to create database with database name starting with _ character.
Error : error while compiling statement: failed: parseexception line 1:4 cannot recognize input near '_a' '' '' in switch database statement
//Please refer screenshot: CDH502-dev-366.png
3. In ADS creating table in _a database is allowed, it shows success message. This ADS behaviour is contradictory to Hive Query Editor, Please let me know your opinion on this.
Hi Anil, Unfortunately, it looks like you can create anything as long as backtics(`) are used. This needs to get fixed by the Hive team. If you try to create the database(_a) or table(_b) without the backtics, it will fail. This is the correct behavior. That said, our ADS create table contains backtics and probably shouldn't. I will discuss with Sachin and see if he thinks we should remove them. Thanks for pointing this out.. Tom
Hi Anil, Unfortunately, it looks like you can create anything as long as backtics(`) are used. This needs to get fixed by the Hive team. If you try to create the database(_a) or table(_b) without the backtics, it will fail. This is the correct behavior. That said, our ADS create table contains backtics and probably shouldn't. I will discuss with Sachin and see if he thinks we should remove them. Thanks for pointing this out.. Tom
Hi Anil, Talked to Sachin sometime back, it was decided to leave the backtics in for create database and table since hive does support this. Thanks, Tom
Hi Anil, Talked to Sachin sometime back, it was decided to leave the backtics in for create database and table since hive does support this. Thanks, Tom
Issue #10795 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 15.0.0-dev-348 |
| No time estimate |
1 issue link |
relates to #11159
Issue #11159In Apache Hive quote identifier missing for column name in Schema Script Generator |
This will get retrofitted in V14 as soon as I retrofit 12118.