Amazon Berkeley Objects Dataset (original) (raw)

CREATE EXTERNAL TABLE IF NOT EXISTS default.abo_images( image_id string, height bigint, width bigint, path string ) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ( 'serialization.format' = ',', 'field.delim' = ',', 'skip.header.line.count'='1' ) LOCATION 's3://amazon-berkeley-objects/images/metadata/' TBLPROPERTIES ( 'has_encrypted_data'='false' )

CREATE EXTERNAL TABLE IF NOT EXISTS default.abo_spins( spin_id string, azimuth bigint, image_id string, height bigint, width bigint, path string ) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ( 'serialization.format' = ',', 'field.delim' = ',', 'skip.header.line.count'='1' ) LOCATION 's3://amazon-berkeley-objects/spins/metadata/' TBLPROPERTIES ( 'has_encrypted_data'='false' )

CREATE EXTERNAL TABLE IF NOT EXISTS default.abo_3dmodels( 3dmodel_id string, path string, meshes bigint, materials bigint, textures bigint, images bigint, image_height_max bigint, image_height_min bigint, image_width_max bigint, image_width_min bigint, vertices bigint, faces bigint, extent_x float, extent_y float, extent_z float ) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ( 'serialization.format' = ',', 'field.delim' = ',', 'skip.header.line.count'='1' ) LOCATION 's3://amazon-berkeley-objects/3dmodels/metadata/' TBLPROPERTIES ( 'has_encrypted_data'='false' )