Cool way to filter files on your bucket for an external table on hive !
CREATE EXTERNAL TABLE mytable1 ( a string, b string, c string ) STORED AS TEXTFILE LOCATION 's3://my.bucket/' 'folder/2009.*\.bz2$';
——————————————————————————————————————————
I put a lot of thoughts into these blogs, so I could share the information in a clear and useful way. If you have any comments, thoughts, questions, or you need someone to consult with, feel free to contact me: