If you attempt to run SQL queries against CSV and XML files in Amazon S3 instances, you will encounter an exception. This is because a streaming result is expected but it defaults to non-streaming.
Description of problem:
There is a problem with lookup querry for csv and xml files from amazon s3 .
More info in Jira.