question Re: Uppercase hive DB name in Archives of Support Questions (Read Only)

Uppercase hive DB name

KuldeepK — Thu, 17 Dec 2015 15:35:10 GMT

Hey Guys,

Is it possible to create hive database name in UPPERCASE ?

hive> create database KULDEEP;
hive> show databases; 
OK 
default 
kuldeep 
test 
Time taken: 0.464 seconds, Fetched: 3 row(s)

Re: Uppercase hive DB name

jstraub — Thu, 17 Dec 2015 16:49:50 GMT

As far as I can tell it is not possible. See this Jira https://issues.apache.org/jira/browse/HIVE-7689

Re: Uppercase hive DB name

nsabharwal — Thu, 17 Dec 2015 19:45:06 GMT

@Kuldeep Kulkarni

Not possible as of now. I just ran few tests but nothing.

Re: Uppercase hive DB name

KuldeepK — Fri, 18 Dec 2015 17:19:47 GMT

Thanks @Neeraj Sabharwal

Re: Uppercase hive DB name

KuldeepK — Fri, 18 Dec 2015 17:22:30 GMT

@Rajesh Balamohan

helped me to find answer of this question.

As per code it always converts given database name in lowercase format

Answer of this questions is - Database names in hive will always be in lowecase.

https://svn.apache.org/repos/asf/hive/trunk/metast...

 @Override
  public void createDatabase(Database db) throws InvalidObjectException, MetaException {
    boolean commited = false;
    MDatabase mdb = new MDatabase();
    mdb.setName(db.getName().toLowerCase());
    mdb.setLocationUri(db.getLocationUri());
    mdb.setDescription(db.getDescription());
    mdb.setParameters(db.getParameters());
    mdb.setOwnerName(db.getOwnerName());
    PrincipalType ownerType = db.getOwnerType();
    mdb.setOwnerType((null == ownerType ? PrincipalType.USER.name() : ownerType.name()));
    try {
      openTransaction();
      pm.makePersistent(mdb);
      commited = commitTransaction();
    } finally {
      if (!commited) {
        rollbackTransaction();
      }
    }
  }