Execute Query

Operation Name

Execute Query

Function overview

Execute SQL Select Queries against Amazon SimpleDB and retrieves the result.

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".

Basic settings

Item name	Required / Optional	Use of Variables	Description	Remarks
Name	Required	Not available	Enter the name on the script canvas.

Required settings

Item name	Required / Optional	Use of Variables	Description	Remarks
Connection	Required	Not available	Select Global Resources. [Add]: Adds new global resource. [Edit list]: Global resource settings can be edited with "Edit Resource list".
SimpleDB query	Required	Available	Specify a query issued against Amazon SimpleDB.
Attribute list	Optional	-	Specify the name of the attribute which is to be retrieved. Each attribute can be operated with the following buttons. [Add]: Add an attribute [Up]: Move the order of the selected attribute upwards by one. [Down]: Move the order of the selected attribute downwards by one. [Delete]: Delete the attribute	Should any attribute name that does not exist in the item is specified, the value returned is null.
Attribute list / Attribute Name	Optional	Available	Enter an attribute name. The attribute of the item specified in the [Select Item And Set Attributes] property action can be used as an attribute name.

Property Action

Item name	Description	Remarks
Select Item And Set Attributes	Open the dialog whereby items can be selected and retrieve the list of attribute names specified in the [Item] and set them to the [Attribute list].	Number of the items that appear in the [Item] list is 500 at most. If the item you are looking for does not appear in the [Item] list, it is possible to list the names of its attributes by entering the item name directly. Enabled when [Connection] is selected.
Execute Query And Enter Attributes	The query specified in the [SimpleDB query] is issued and the result is set to the [Attribute list].	If the query returns multiple items, the attributes of all of those items are set. Enabled when [Connection] is selected.

Get option

Item name	Required / Optional	Use of Variables	Description	Remarks
Enable consistent read	Optional	-	Select whether to have to the operation perform ConsistentRead. [Checked]: The operation performs ConsistentRead. [Not Checked]: (default) The operation does not perform ConsistentRead.	If 'ConsistentRead' is not performed, any data written to Amazon SimpleDB before its read operation may not have been reflected in the result returned. If 'ConsistentRead' is performed, any data which has been written to the database prior to its subsequent read operation is reflected in the returned result, however the performance may be adversely affected.

Data processing method

Item name	Required / Optional	Use of Variables	Description	Remarks
Mass data processing	Required	Not available	Select a data processing method. [Use script settings]: (default) Apply mass data processing settings of script property to adapter. [Disable]: Mass data processing is not performed. [Enable]: Mass data processing is performed.

Comment

Item name	Required / Optional	Use of Variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this adapter. The description will be reflected in the specifications.

Schema

Input Schema

None.

Output Schema

<?xml version="1.0" ?>
<table>
  <row>
    <column>Item name</column>
    <column>Attribute value</column>
    :
  </row>
  <row>
    :
  </row>
</table>

Loading schema in Mapper

Schema is loaded automatically.

See "Edit Schema" for details with regards to defining a schema.

Mass data processing

Mass data processing is supported.

PSP Usage

PSP is supported.

For details on PSP, refer to "Parallel Stream Processing".

Available component variables

Component variable name	Description	Remarks
count	Returns the number of items successfully read.	The value defaults to null. Null when using Parallel Stream Processing.
error_code	When AmazonServiceException is thrown, Amazon Web Services error code to which it corresponds is stored.	The value defaults to null. Null when using Parallel Stream Processing.
status_code	When AmazonService Exception is thrown, HTTP status code is stored.	The value defaults to null. Null when using Parallel Stream Processing.
message_category	Stroes the category to which corresponding message code belongs to, when an error occurs.	The value defaults to null.
message_code	Stores its corresponding message code of occured error.	The value defaults to null.
message_level	Stores the severity of the corresponding message code of the occured error.	The value defaults to null.
error_type	Stores the type of the occured error.	The value defaults to null. Error is represented in the format depicted below. Example:java.io.FileNotFoundException The message may vary depending on the DataSpider Servista version.
error_message	Stores the error message for the occured error.	The value defaults to null. The message may vary depending on the DataSpider Servista version.
error_trace	Stores stack trace of the occurred error.	The value defaults to null. The message may vary depending on the DataSpider Servista version or the client application used.

Specification limitations

Regardless of the number of the values assigned to a single attribute, only one of them will be retrieved. What value will be retrieved is dependent on Amazon SimpleDB and is not specifiable in advance.

If nothing is specified by the [Attribute list], the name of the items returned in the query result are read.

The order of the [Attribute list] returned in the 'Item selection dialog' is not guaranteed.

The order of the [Attribute list] retrieved by executing [Execute Query And Enter Attributes] Is not guaranteed.

The number of comparative operators allowed in a [SimpleDB query] has a maximum limit of 20.

Main exceptions

Exception name	Causes	Solution
ResourceNotFoundException Resource definition could not be found.Name: []	[Connection] is not specified.	Please specify [Connection].
ResourceNotFoundException Resource definition could not be found.Name: [<name of Global Resources>]	Resource definition selected in [Connection] is not found.	Please check the global resource specified in [Connection].
InvalidPropertyConfigurationException <Property Name> is not specified.	[<Property Name>] is not specified.	Please specify [<Property Name>].
InvalidQueryExpressionException The specified query expression syntax is not valid.	The query specified in the [<SimpleDB query>] is invalid.	Check the query string specified in the [SimpleDB query].
Status Code: 400, AWS Request ID: XXXXXXXXXXXXXXXX, AWS Error Code: NoSuchDomain, AWS Error Message: The specified domain does not exist	The domain specified in the [Domain name] does not exist.	Make sure that the domain name specified in [Domain name] is valid.
Status Code: 403, AWS Request ID: XXXXXXXXXXXXXXXX, AWS Error Code: InvalidClientTokenId, AWS Error Message: The AWS Access Key Id you provided does not exist in our records.	[Access Key ID] specified in [Connection] is invalid.	Check the settings of the global resource specified in [Connection].
Status Code: 403, AWS Request ID: XXXXXXXXXXXXXXXX, AWS Error Code: SignatureDoesNotMatch, AWS Error Message: The request signature we calculated does not match the signature you provided. Check your AWS Secret Access Key and signing method. Consult the service documentation for details.	[Secret Access Key] specified in [Connection] is invalid.	Check the settings of the global resource specified in [Connection].
com.amazonaws.AmazonClientException Unable to execute HTTP request: <Endpoint>	[Endpoint] specified by [Connection] is not available.	Make sure that all properties specified within the [Connection] for the specified Global Resource are provided with correct information.

Notes

Use HTTPS for communicating between Amazon SimpleDB and this adapter.

For further information regarding query strings that can be specifiable in the [SimpleDB query], please refer to [Using Amazon SimpleDB]-[Using Select to Create Amazon SimpleDB Queries] in 'Amazon SimpleDB Developer Guide' (http://docs.amazonwebservices.com/AmazonSimpleDB/latest/DeveloperGuide/)