Details
-
Type:
Story
-
Status: To Do
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: dax
-
Labels:None
-
Story Points:12
-
Epic Link:
-
Team:SQuaRE
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
- relates to
-
DM-41913 TAP service misidentifies types of some computed columns
- To Do
Made a PR to CADC upstream, and it has the full type detection of the system. This is deployed in a few places on a private build, but we're waiting for the upstream PR to get fixed.