INFORMATION_SCHEMA is part of the SQL92 standard. This is a feature supported and widely used in most mature RDBMs. The idea is to enable that for Hive as well.
https://issues.apache.org/jira/browse/HIVE-1010 On Fri, Mar 2, 2018 at 10:59 AM, Vihang Karajgaonkar <vih...@cloudera.com> wrote: > I recently noticed the work done in HIVE-16946 > <https://issues.apache.org/jira/browse/HIVE-16946> related to information > schema. Based on what I understand so far, it uses JdbcSerDe to create hive > tables similar to metastore db tables. It looks like an interesting idea. Can > someone share how is it used and what was the motivation to add it? > > Thanks, > Vihang