Hai Dam

Amazon has generated a lot of excitement around their recent release of Athena, an ANSI-standard query tool that works with data stored in Amazon S3. Athena and S3 can deliver results quickly and with the power of sophisticated data warehousing systems. This article covers 9 things you should know about Athena when considering it as a query service. 1. Schema and Table Definitions To be able to query data with Athena, you will need to make sure you have data residing on S3. With data on S3 you will need to create a database and tables. When creating schemas for the data on S3 the positional order is important. For example, if you have a source file with “ID”, ”DATE”, ”CAMPAIGNID”, ”RESPONSE”, ”ROI” and ”OFFERID” columns, then your schema should reflect that structure. “ID”,”DATE”,”CAMPAIGNID”,”RESPONSE”,”ROI”,”OFFERID” “0122”,”December 10, 2015",”123432100A”,”8.43",”A102B”,”4985" “0123”,”December 10, 2015",”543421111A”,”2.61",”A904F”,”3212&qu