Oracle show create table

select dbms_metadata.get_ddl('TABLE','table_name','db_name') from dual;
select dbms_metadata.get_ddl('INDEX','index_name','db_name') from dual;

Oracle show indexes/indices

select index_name from dba_indexes where table_name='tablename';

pig : set default parallelism at the script level

SET default_parallel 100; -- make it the first line in the script

Everything you wanted to know about Pig

http://wiki.apache.org/pig/PigLatin

http://pig.apache.org/docs/r0.7.0/piglatin_ref1.html

http://wiki.apache.org/pig/PigStreamingFunctionalSpec

http://search.safaribooksonline.com/book/databases/hadoop/9780596521974/pig/301


http://pig.apache.org/docs/r0.7.0/piglatin_ref2.html#CONCAT

http://ofps.oreilly.com/titles/9781449302641/index.html

Mysql to Pig converter

mysql to pig converter

Source

Oracle previous command

SQL> edit
----
edit the command
-----
/

Oracle show tables

select * from user_objects where object_type = 'TABLE';