[PIG-2482] Integrate HCat DDL command into Pig - ASF JIRA

XML

Word

Printable

JSON

Hadoop Flags:

Reviewed
Release Note:

Hide
Pig support sql command in script/grunt/embedding.

Script/grunt:
sql create table ......;

Note the sql statement end with a ";"

embedding:
from org.apache.pig.scripting import Pig
ret = Pig.sql("""drop table if exists table_1;""")
if ret==0:
#success

Configuration:
pig.sql.type=hcat (backend of sql, hcat is the only sql backend now)
hcat.bin=/usr/local/hcat/bin/hcat (binary location for hcat)

Show
Pig support sql command in script/grunt/embedding. Script/grunt: sql create table ......; Note the sql statement end with a ";" embedding: from org.apache.pig.scripting import Pig ret = Pig.sql("""drop table if exists table_1;""") if ret==0: #success Configuration: pig.sql.type=hcat (backend of sql, hcat is the only sql backend now) hcat.bin=/usr/local/hcat/bin/hcat (binary location for hcat)

We would like to run hcat DDL command inside Pig script or Grunt. We can use a similar approach as "fs" or "sh".

Grunt> hcat create table .....

Similar to "fs" and "sh", we don't plan to add Java API in PigServer for it.