Impala之DDL数据定义和DML数据操作

1.创建数据库

CREATE DATABASE [IF NOT EXISTS] database_name
  [COMMENT database_comment]
  [LOCATION hdfs_path];

注：Impala不支持WITH DBPROPERTIE…语法，但是在Hive中可以

[cdh2:21000] > create database db_hive WITH DBPROPERTIES('name' = 'Andy');

Query: create database db_hive
WITH DBPROPERTIES('name' = 'ttt')
ERROR: AnalysisException: Syntax error in line 2:

WITH DBPROPERTIES('name' = 'ttt')
Encountered: WITH
Expected: COMMENT,
LOCATION

2.查询数据库

2.1 显示数据库

[cdh2:21000] > show databases;

[cdh2:21000] > show databases like 'hive*';

Query: show databases like 'hive*'
+---------+---------+
| name   | comment |
+---------+---------+
| hive_db |         |
+---------+---------+

[cdh2:21000] > desc database hive_db;

Query: describe database hive_db
+---------+----------+---------+
| name   | location | comment |
+---------+----------+---------+
| hive_db |          |         |
+---------+----------+---------+

2.2 删除数据库

[cdh2:21000] > drop database hive_db;

[