awslabs/voice-powered-analytics

Workshop to build voice enabled integration with data analytics

voice-powered-analytics's Issues

Query Error in Athena

Hi,
I tried to run the query to create a table in Athena using this code:
CREATE EXTERNAL TABLE IF NOT EXISTS default.tweets(
id bigint COMMENT 'Tweet ID',
text string COMMENT 'Tweet text',
created timestamp COMMENT 'Tweet create timestamp',
screen_name string COMMENT 'Tweet screen_name',
screen_name_followers_count int COMMENT 'Tweet screen_name follower count',
place string COMMENT 'Location full name',
country string COMMENT 'Location country',
retweet_count int COMMENT 'Retweet count',
favorite_count int COMMENT 'Favorite count')
ROW FORMAT SERDE
'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
'paths'='id,text,created,screen_name,screen_name_followers_count,place_fullname,country,retweet_count,favorite_count')
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
's3://aws-vpa-tweets/tweets/'

I changed the location according to Ireland but when I run the query in the query editor in Athena, I get the following error:

Your query has the following error(s):

Unable to verify/create output bucket aws-vpa-tweets-euw1 (Service: AmazonAthena; Status Code: 400; Error Code: InvalidRequestException; Request ID: 890390cf-1db9-40d3-9259-ba7798be20dd)

Lambda not writing to s3 and therefore 404 error

Hey i am going through this workshop and when i copy in the lambda, fill out the env and provided and get the bucket from the stack i get:

errorMessage": "An error occurred (404) when calling the HeadObject operation: Not Found",
  "errorType": "ClientError",

When it is trying to 's3_client.download_file(s3_bucket, s3_key[1:], "/tmp/results.csv")'

I looked in the bucket and there is no data in there which is correct.

it seems the athena output location isnt working. Can you help please

Tried doing this for my own data but cant seem to pickup the 2nd question

Hi again,

So after the success of the last one i wanted to run this against my data sets with my own questions.
However when i get to the last stay of asking the Alexa she can find my skill but not answer the question 'whats my ' .
the 1st lambda works and the alexa can find my skill but its the specific question it dosent like.
Would you guys be able to help? not sure what specifics you need to solve this as i I have changed the name and she responses with
'There was a problem with the requested skill's response'

Can't download the tweet file

Hi,
I've tried us-east1 and ireland, but I keep getting this error:

$ aws s3 cp s3://aws-vpa-tweets/tweets/2017/11/06/04/aws-vpa-tweets-1-2017-11-06-04-23-28-2020b61e-ac18-4c9e-b446-6a49f8cced21.gz .

fatal error: An error occurred (404) when calling the HeadObject operation: Key "tweets/2017/11/06/04/aws-vpa-tweets-1-2017-11-06-04-23-28-2020b61e-ac18-4c9e-b446-6a49f8cced21.gz" does not exist

Let me know how I can access this file please :)

I've tried the AWS CLI from Windows, Windows bash and an AWS instance in us-east1 - all same error!