Questions about amazon-athena
Read more about amazon-athena
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to print the required output with the help of SQL
I have tables 'users' and 'user_transactions' in AWS Athena. The table has many columns but I am interested in 2 columns viz. user name and txn_type.
The txn_type column has 3 possible values viz. FT,...
azaveri7
Votes: 0
Answers: 1
double quotes on all keys and all values in athena query result
Preface:
I defined an Athena table in AWS, using s3 as the source (defined it manually without glue crawler).
The files contain data from Eventbridge, and each record in them is separated with newline...
localhost
Votes: 0
Answers: 1
AWS Athena MSCK REPAIR TABLE "table_name" Error adding new partitions
When trying to refresh the partitions in a AWS Athena/Glue table I am getting this error
line 1:1: mismatched input 'MSCK'. Expecting: 'ALTER', 'ANALYZE',
'CALL', 'COMMIT', 'CREATE', 'DEALLOCATE', 'D...
Eduardo Rodrigues
Votes: 0
Answers: 2
How to transform data in Amazon Athena
I have some data in S3 location in json format. It have 4 columns val, time__stamp, name and type. I would like to create an external Athena table from this data with some transformations given below:...
ndev
Votes: 0
Answers: 2