Hadoop DDL

[#1]

Hello -

Can you specify character column lengths when executing ddl (specifically create table statement) in Hadoop?

Is there any documentation on table datatypes?

Any input would be much appreciated.

[#2 · Accepted solution]

@Avery Long

this is an extensive description of what Hive has to offer https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL

[#3]

Thanks Artem!

I'm not seeing anything for specifying a length.

Example:

create table foo

(

name string(10)

)

or

create table foo

(

name string length=10

)

Something similar to able.

[#4]

@Avery Long https://dzone.com/articles/hive-data-types actually a good description for string data types including length here http://hadooptutorial.info/hive-data-types-examples/#String_Data_Types