Ws_Sql Invalid table name or file type not supported: test

[bobl]

Hi,

I run into a problem with Ws_SQL Web Services. When I use the PrepareSQL method soap test. I can't query table.

Request:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns="urn:hpccsystems:ws:ws_sql">
<soap:Body>
  <PrepareSQLRequest>
   <SqlText>select * from test</SqlText>
   <TargetCluster>hthor</TargetCluster>
   <TargetQuerySet/>
   <Wait>-1</Wait>
  </PrepareSQLRequest>
</soap:Body>
</soap:Envelope>

Response:

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/04/secext">
<soap:Body>
  <PrepareSQLResponse xmlns="urn:hpccsystems:ws:ws_sql">
   <Exceptions>
    <Exception>
     <Code>-1</Code>
     <Audience>user</Audience>
     <Source>CSoapResponseBinding</Source>
     <Message>2014-11-24 06:32:30 GMT: Invalid table name or file type not supported: test
</Message>
    </Exception>
   </Exceptions>
  </PrepareSQLResponse>
</soap:Body>
</soap:Envelope>

following are the GetDBMetaData

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/04/secext">
<soap:Body>
  <GetDBMetaDataResponse xmlns="urn:hpccsystems:ws:ws_sql">
   <TableCount>0</TableCount>
   <QuerySets>
    <QuerySet>
     <Name>hthor</Name>
     <QuerySetQueries>
      <QuerySetQuery>
       <Name>test</Name>
       <Id>test.1</Id>
       <Wuid>W20141124-101734</Wuid>
       <Suspended>1</Suspended>
       <Signature>
        <ResultSets>
         <ResultSet>
          <name>Result 1</name>
          <OutParams>
           <OutParam>
            <Name>personid</Name>
            <Type>unsigned1</Type>
           </OutParam>
           <OutParam>
            <Name>name</Name>
            <Type>string25</Type>
           </OutParam>
           <OutParam>
            <Name>age</Name>
            <Type>integer8</Type>
           </OutParam>
           <OutParam>
            <Name>height</Name>
            <Type>integer8</Type>
           </OutParam>
           <OutParam>
            <Name>address</Name>
            <Type>string25</Type>
           </OutParam>
          </OutParams>
         </ResultSet>
        </ResultSets>
       </Signature>
      </QuerySetQuery>
      <QuerySetQuery>
       <Name>bobtest</Name>
       <Id>bobtest.1</Id>
       <Wuid>W20141124-134421</Wuid>
       <Suspended>0</Suspended>
       <Signature>
        <ResultSets>
         <ResultSet>
          <name>Result 1</name>
          <OutParams>
           <OutParam>
            <Name>personid</Name>
            <Type>unsigned1</Type>
           </OutParam>
           <OutParam>
            <Name>firstname</Name>
            <Type>string15</Type>
           </OutParam>
           <OutParam>
            <Name>lastname</Name>
            <Type>string25</Type>
           </OutParam>
          </OutParams>
         </ResultSet>
        </ResultSets>
       </Signature>
      </QuerySetQuery>
     </QuerySetQueries>
     <QuerySetAliases>
      <QuerySetAlias>
       <Id>test.1</Id>
       <Name>test</Name>
      </QuerySetAlias>
      <QuerySetAlias>
       <Id>bobtest.1</Id>
       <Name>bobtest</Name>
      </QuerySetAlias>
     </QuerySetAliases>
    </QuerySet>
    <QuerySet>
     <Name>thor</Name>
    </QuerySet>
    <QuerySet>
     <Name>roxie</Name>
    </QuerySet>
    <QuerySet>
     <Name>thor_roxie</Name>
    </QuerySet>
   </QuerySets>
   <ClusterNames>
    <ClusterName>hthor</ClusterName>
    <ClusterName>thor</ClusterName>
    <ClusterName>roxie</ClusterName>
    <ClusterName>thor_roxie</ClusterName>
   </ClusterNames>
  </GetDBMetaDataResponse>
</soap:Body>
</soap:Envelope>

following are the create 'test' table code,

Code: Select all

Layout_Person := RECORD
  UNSIGNED1 PersonID;
  STRING25  Name;
  INTEGER   age;
  INTEGER   height;
  STRING25  address;

END;

t := DATASET([ {1,'bob',23,180,'xian'},
                       {2,'ivy',28,160,'gaolin'},
                       {3,'leo',28,180,'xian'},
                       {4,'neal',35,175,'tangyanlu'},
                        {5,'owen',32,170,'tianshui'},
                        {6,'jake',34,170,'wuhanxiangyang'}],Layout_Person);

test := t;

//  Outputs  ---
test;

I am not able to figure out what I am doing wrong. and I don't know how to set the tablename.

Thanks
Bob

[bobl]

This problem has been resolved