athena-express | simplify executing SQL queries in Amazon Athena | AWS library

by ghdna JavaScript Version: v7.1.0 License: MIT

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | athena-express Summary

athena-express is a JavaScript library typically used in Cloud, AWS, Nodejs, Amazon S3 applications. athena-express has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can install using 'npm i rrcalvo-fix-athena-express' or download it from GitHub, npm.

Athena-Express can simplify executing SQL queries in Amazon Athena AND fetching cleaned-up JSON results in the same synchronous or asynchronous request - well suited for web applications.

Support

Quality

Security

License

Reuse

Support

athena-express has a low active ecosystem.

It has 167 star(s) with 53 fork(s). There are 10 watchers for this library.

It had no major release in the last 12 months.

There are 13 open issues and 49 have been closed. On average issues are closed in 89 days. There are 17 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of athena-express is v7.1.0

Quality

athena-express has 0 bugs and 0 code smells.

Security

athena-express has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

athena-express code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

athena-express is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

athena-express releases are available to install and integrate.

Deployable package is available in npm.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi has reviewed athena-express and discovered the below as its top functions. This is intended to give you an instant insight into athena-express implemented functionality, and help decide if they suit your requirements.

Gets the results from a S3 query string
Checks if the query has been completed
Adds provided data type to the object .
Start query execution
Clean up the line of markdown .
Formats an array of D3D results into a JSON object .
Clean input string
Return an array with raw results from a stream .
Validates the constructor parameters
Get the data types in the S3 .

Get all kandi verified functions for this library.

athena-express Key Features

No Key Features are available at this moment for athena-express.

athena-express Examples and Code Snippets

No Code Snippets are available at this moment for athena-express.

Community Discussions

Trending Discussions on athena-express

Lambda function to query AWS Athena gives timeout

QUESTION

Lambda function to query AWS Athena gives timeout

Asked 2020-Apr-22 at 10:33

I have written a Lambda function using athena-express that queries AWS Athena with S3 Parquet files as destination. Also using AWS Glue for ETL processes to S3. I am receiving: "Task timed out after 6.01 seconds". Increasing the timeout gives me the same message but with higher amount of timeout seconds. The strange thing is that it works locally, but not when it's deployed to AWS. Code should work. I think something is missing in AWS configurations.

I have followed the instructions and using lambda settings: https://www.npmjs.com/package/athena-express. I have added AmazonAthenaFullAccess and AmazonS3FullAccess policies to the Execution role for the Lambda function.

...

ANSWER

Answered 2020-Apr-22 at 10:33

When you say it works locally I assume that when you run it locally you have no timeout on the code. Athena is not a low latency database, and queries very rarely run in less than a few seconds, and often in minutes – it all depends on how much data they scan and other factors.

Your Lambda function must have a timeout that is longer than the longest run time of the queries you run with it. If those queries run for more than a minute, the timeout must be more than a minute, if they run for more than ten minutes, your timeout must be more than ten minutes, and so on.

In general, long running queries is not a great fit for Lambda and API Gateway that are made for more low latency situations. Since your queries seem to run for minutes I suggest that you look other ways of solving your problem. If you provide more context about what you are trying to do, we may be able to help you with that.

Source https://stackoverflow.com/questions/61355607

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install athena-express

You can install using 'npm i rrcalvo-fix-athena-express' or download it from GitHub, npm.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: