Howl CLI Functional Specification

This wiki page outlines what is supported from Howl CLI.

In http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL Hive's DDL spec outlines various allowed operations. This wiki will talk about which of those are allowed and are not allowed from Howl CLI. Among those which are allowed how are they different from Hive's CLI.

CREATE TABLE

[STORED AS file_format] file_format:

will be modified to support

[STORED AS file_format] file_format:

CREATE TABLE AS SELECT

CREATE TABLE LIKE

DROP TABLE

ALTER TABLE

ALTER TABLE table_name ADD partition_spec [ LOCATION 'location1' ] partition_spec [ LOCATION 'location2' ] ...

Alter Table File Format

ALTER TABLE table_name SET FILEFORMAT file_format

Here file_format must be same as the one described above in CREATE TABLE. Else, throw an exception "Operation not supported. Not a valid file format."

Change Column Name/Type/Position/Comment

ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name column_type [COMMENT col_comment] [FIRST|AFTER column_name]

Add/Replace Columns

ALTER TABLE table_name ADD|REPLACE COLUMNS (col_name data_type [COMMENT col_comment], ...)

Alter Table Touch

ALTER TABLE table_name TOUCH; ALTER TABLE table_name TOUCH PARTITION partition_spec;

CREATE VIEW

DROP VIEW

ALTER VIEW

SHOW TABLES

SHOW PARTITIONS

SHOW FUNCTIONS

DESCRIBE

Any other commands apart from one listed above will result in an exception with message "Operation Not Supported".

User Interface for Howl

It will support following four command line options:

Notes:

Howl/HowlCliFuncSpec (last edited 2010-09-02 18:51:16 by AshutoshChauhan)