title: PyGreSQL AWS Glue Python
body: <p>I'm trying to use the PyGreSQL package in AWS Glue with a Python job.</p>
  <p>I have uploaded to a S3 bucket the wheel file from here:</p>
  <pre><code>https://pypi.org/project/PyGreSQL/#files
  </code></pre>
  <p>the 3.6 for x64</p>
  <p>then in the job I use:</p>
  <pre><code>import pg
  </code></pre>
  <p>with this configuration I get the following error when running the job:</p>
  <pre><code>
  WARNING: The directory '/.cache/pip' or its parent directory is not owned or is not writable by the current user. The cache has been disabled. Check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
  
  2020-08-08T20:22:47.845+02:00
  Traceback (most recent call last):
    File &quot;/tmp/runscript.py&quot;, line 123, in &lt;module&gt;
      runpy.run_path(temp_file_path, run_name='__main__')
    File &quot;/usr/local/lib/python3.6/runpy.py&quot;, line 263, in run_path
      pkg_name=pkg_name, script_name=fname)
    File &quot;/usr/local/lib/python3.6/runpy.py&quot;, line 96, in _run_module_code
      mod_name, mod_spec, pkg_name, script_name)
    File &quot;/usr/local/lib/python3.6/runpy.py&quot;, line 85, in _run_code
      exec(code, run_globals)
    File &quot;/tmp/glue-python-scripts-vbox2q05/postloading3.py&quot;, line 7, in &lt;module&gt;
    File &quot;/glue/lib/installation/pg.py&quot;, line 1436, in &lt;module&gt;
      set_query_helpers(_dictiter, _namediter, _namednext, _scalariter)
  NameError: name 'set_query_helpers' is not defined
  
  During handling of the above exception, another exception occurred:
  
  Traceback (most recent call last):
    File &quot;/tmp/runscript.py&quot;, line 142, in &lt;module&gt;
      raise e_type(e_value).with_traceback(new_stack)
    File &quot;/tmp/glue-python-scripts-vbox2q05/postloading3.py&quot;, line 7, in &lt;module&gt;
    File &quot;/glue/lib/installation/pg.py&quot;, line 1436, in &lt;module&gt;
      set_query_helpers(_dictiter, _namediter, _namednext, _scalariter)
  NameError: name 'set_query_helpers' is not defined
  </code></pre>
  <p>do you know if I'm missing some dependency library to upload? according to AWS the PyGreSQL is compatible with Glue</p>