native_apps_blog_ext_tbl.sql

/**
 * Gautam Muralidhar, Srivatsan Ramanujam, Nov-2014
 * External Table defs.
**/
create external table ocv.src_image_ext 
(
    img_name varchar,
    img varchar
)
LOCATION('pxf://hdm1:50070/user/user-name/opencvexample/imgseqfile/part-r-00000?Profile=HdfsTextSimple')
FORMAT 'TEXT' (delimiter = E'\t');

--Create a table to save the sequence file 
create table ocv.src_image 
as
(
    select * 
    from ocv.src_image_ext
)
distributed by (img_name);