I created 2 EXTERNAL TABLE in EMR with mapping to DynamoDB. The table names are Attributes and AttributeTypes.
In Attribute, I store id of AttributeType as attributeTypeId.
How I want to run query on the EMR hive from my NodeJS application incluging JOIN, WHERE, ORDER and LIMIT. How can I do it from the NodeJS application. So far I have only been successful runing queries from the AWS CLI, and can find nothing in the AWS SDK.