René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"The casjobs query results involving bigint column produce errors. ","articleBody":"Hi,\r\n\r\nWhen trying to query the skyserver/casjobs I can do it without issues if I don't ask for the specobjid column in a query , but if I add it, I'm getting a bunch of errors. \r\n\r\nThe simple  code  (based on the example) is given below\r\n```python\r\nimport SciServer\r\nfrom SciServer import Authentication, LoginPortal, Config, CasJobs, SkyQuery, SciDrive, SkyServer, Files, Jobs\r\nimport os\r\nimport pandas\r\nimport sys\r\nimport json\r\nfrom io import StringIO\r\nfrom io import BytesIO\r\n#from PIL import Image                                                                                                                                                   \r\nimport numpy as np\r\nimport matplotlib.pyplot as plt\r\n\r\nAuthentication_loginName = '**'  #CHANGE ME \r\nAuthentication_loginPassword = '**'\r\n\r\ntoken1 = LoginPortal.login(Authentication_loginName,\r\n                           Authentication_loginPassword)\r\n\r\ncasJobsId = CasJobs.getSchemaName()\r\nprint(casJobsId)\r\nQuery = ' select top 10 ra,dec from specphotoall'  # this works                                                                                                          \r\nQuery = ' select top 10 ra,dec,plate from specphotoall'  # this works                                                                                                    \r\nQuery = ' select top 10 ra,dec,specobjid from specphotoall'  #this doesn't                                                                                               \r\ndf = CasJobs.executeQuery(sql=Query, context='DR16', format=\"fits\")\r\n\r\nfd = open('xx.fits', 'wb')\r\nfd.write(df.read())\r\nfd.close()\r\n```\r\n\r\nThe error is\r\n```\r\nTraceback (most recent call last):\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py\", line 685, in _update_chunk_length\r\n    self.chunk_left = int(line, 16)\r\nValueError: invalid literal for int() with base 16: b''\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nTraceback (most recent call last):\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py\", line 425, in _error_catcher\r\n    yield\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py\", line 752, in read_chunked\r\n    self._update_chunk_length()\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py\", line 689, in _update_chunk_length\r\n    raise httplib.IncompleteRead(line)\r\nhttp.client.IncompleteRead: IncompleteRead(0 bytes read)\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nTraceback (most recent call last):\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/requests/models.py\", line 751, in generate\r\n    for chunk in self.raw.stream(chunk_size, decode_content=True):\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py\", line 560, in stream\r\n    for line in self.read_chunked(amt, decode_content=decode_content):\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py\", line 781, in read_chunked\r\n    self._original_response.close()\r\n  File \"/home/koposov/python36/lib/python3.6/contextlib.py\", line 99, in __exit__\r\n    self.gen.throw(type, value, traceback)\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/urllib3/response.py\", line 443, in _error_catcher\r\n    raise ProtocolError(\"Connection broken: %r\" % e, e)\r\nurllib3.exceptions.ProtocolError: ('Connection broken: IncompleteRead(0 bytes read)', IncompleteRead(0 bytes read))\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nTraceback (most recent call last):\r\n  File \"doit.py\", line 23, in \u003cmodule\u003e\r\n    df = CasJobs.executeQuery(sql=Query, context='DR16', format=\"fits\")\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/SciServer-2.0.13-py3.6.egg/SciServer/CasJobs.py\", line 171, in executeQuery\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/requests/models.py\", line 829, in content\r\n    self._content = b''.join(self.iter_content(CONTENT_CHUNK_SIZE)) or b''\r\n  File \"/home/koposov/pyenv36/lib/python3.6/site-packages/requests/models.py\", line 754, in generate\r\n    raise ChunkedEncodingError(e)\r\nrequests.exceptions.ChunkedEncodingError: ('Connection broken: IncompleteRead(0 bytes read)', IncompleteRead(0 bytes read))\r\n```\r\nBackground info. I'm using sciserver-2.0.13 and python 3.6.10 on linux. \r\n\r\nThanks \r\n      Sergey","author":{"url":"https://github.com/segasai","@type":"Person","name":"segasai"},"datePublished":"2020-03-25T18:12:11.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/10/SciScript-Python/issues/10"}