Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-17872

TAP returns incorrect column type when SELECT contains math

    XMLWordPrintable

Details

    • Story
    • Status: To Do
    • Resolution: Unresolved
    • None
    • dax
    • None

    Description

      When I submit the query 

      SELECT ra, decl, w1mag, w1mag - w2mag FROM wise_00.allwise_p3as_psd
      WHERE qserv_areaspec_circle(283.831250,-30.545278,0.20)=1

      through pyvo, the values in the result column "w1mag - w2mag" are all strings instead of floats. Manipulating the results with pandas seems to kind of work anyways, but it becomes excruciatingly slow.

      I can check what the XML looks like with:

      query_string = ("SELECT ra, decl, w1mag, w1mag - w2mag FROM wise_00.allwise_p3as_psd "
      {{ "WHERE qserv_areaspec_circle(283.831250,-30.545278,0.20)=1 ")}}
      query = pyvo.dal.TAPQuery(query=query_string, baseurl='http://lsst-lsp-stable.ncsa.illinois.edu/api/tap')
      res = query.execute_stream()
      res_str = res.read()
      res_str[:1500]

      and I see: 

      <FIELD name="w1mag - w2mag" datatype="char" arraysize="*" />

       

       

      Attachments

        Issue Links

          Activity

            ctslater Colin Slater created issue -
            cbanek Christine Banek made changes -
            Field Original Value New Value
            Assignee Christine Banek [ cbanek ]
            fritzm Fritz Mueller made changes -
            Team Data Access and Database [ 10204 ] SQuaRE [ 10302 ]
            cbanek Christine Banek made changes -
            Status To Do [ 10001 ] In Progress [ 3 ]
            cbanek Christine Banek made changes -
            Issue Type Bug [ 1 ] Story [ 10001 ]
            cbanek Christine Banek made changes -
            Epic Link DM-22752 [ 428069 ]
            cbanek Christine Banek made changes -
            Story Points 2
            cbanek Christine Banek made changes -
            Status In Progress [ 3 ] To Do [ 10001 ]
            cbanek Christine Banek made changes -
            Epic Link DM-22752 [ 428069 ] DM-22761 [ 428079 ]
            frossie Frossie Economou made changes -
            Epic Link DM-22761 [ 428079 ] DM-23708 [ 431296 ]
            frossie Frossie Economou made changes -
            Epic Link DM-23708 [ 431296 ] DM-25255 [ 435598 ]
            cbanek Christine Banek made changes -
            Rank Ranked lower
            frossie Frossie Economou made changes -
            Status To Do [ 10001 ] In Progress [ 3 ]
            frossie Frossie Economou made changes -
            Reviewers Frossie Economou [ frossie ]
            Status In Progress [ 3 ] In Review [ 10004 ]
            frossie Frossie Economou made changes -
            Status In Review [ 10004 ] Reviewed [ 10101 ]
            frossie Frossie Economou made changes -
            Resolution Done [ 10000 ]
            Status Reviewed [ 10101 ] Done [ 10002 ]
            frossie Frossie Economou made changes -
            Resolution Done [ 10000 ]
            Status Done [ 10002 ] To Do [ 10001 ]
            cbanek Christine Banek made changes -
            Story Points 2 12
            cbanek Christine Banek made changes -
            Status To Do [ 10001 ] In Progress [ 3 ]
            cbanek Christine Banek made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Done [ 10002 ]
            frossie Frossie Economou made changes -
            Epic Link DM-25255 [ 435598 ] DM-30590 [ 511627 ]
            gpdf Gregory Dubois-Felsmann made changes -
            Attachment screenshot-1.png [ 67121 ]
            gpdf Gregory Dubois-Felsmann made changes -
            Link This issue relates to DM-41913 [ DM-41913 ]
            gpdf Gregory Dubois-Felsmann made changes -
            Resolution Done [ 10000 ]
            Status Done [ 10002 ] To Do [ 10001 ]

            People

              cbanek Christine Banek
              ctslater Colin Slater
              Frossie Economou
              Christine Banek, Colin Slater, Fritz Mueller, Frossie Economou, Gregory Dubois-Felsmann
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Jenkins

                  No builds found.