title: AWS push down predicate not working when reading HIVE partitions
body: <p>Trying to test out some glue functionality and  the push down predicate is not working on avro files within S3 that were partitioned for use in HIVE.  Our partitions are as follows:  YYYY-MM-DD.  </p>
  
  <pre><code>import sys
  from awsglue.transforms import *
  from awsglue.utils import getResolvedOptions
  from pyspark.context import SparkContext
  from awsglue.context import GlueContext
  from awsglue.job import Job
  
  ## @params: [JOB_NAME]
  args = getResolvedOptions(sys.argv, ['JOB_NAME'])
  
  sc = SparkContext()
  glueContext = GlueContext(sc)
  spark = glueContext.spark_session
  job = Job(glueContext)
  job.init(args['JOB_NAME'], args)
  
  filterpred = "loaddate == '2019-08-08'"
  
  datasource0 = glueContext.create_dynamic_frame.from_catalog(database = "hive", 
                                                              table_name = "stuff", 
                                                              pushDownPredicate = filterpred)
  print ('############################################')
  print "COUNT: ", datasource0.count()
  print ('##############################################')
  
  df = datasource0.toDF()
  df.show(5)
  
  job.commit()
  </code></pre>
  
  <p>However I still see glue pulling in dates way outside of the range.:</p>
  
  <pre><code>Opening 's3://data/2018-11-29/part-00000-a58ee9cb-c82c-46e6-9657-85b4ead2927d-c000.avro' for reading
  2019-09-13 13:47:47,071 INFO [Executor task launch worker for task 258] s3n.S3NativeFileSystem (S3NativeFileSystem.java:open(1208)) -
  Opening 's3://data/2017-09-28/part-00000-53c07db9-05d7-4032-aa73-01e239f509cf.avro' for reading
  </code></pre>
  
  <p>I tried using the examples in the following:</p>
  
  <p><a href="https://stackoverflow.com/questions/54833263/aws-glue-dynamicframes-and-push-down-predicate">AWS Glue DynamicFrames and Push Down Predicate</a></p>
  
  <p><a href="https://stackoverflow.com/questions/54833263/aws-glue-dynamicframes-and-push-down-predicate">AWS Glue DynamicFrames and Push Down Predicate</a></p>
  
  <p><a href="https://stackoverflow.com/questions/56079448/aws-glue-pushdown-predicate-not-working-properly">AWS Glue pushdown predicate not working properly</a></p>
  
  <p>And currently none of the solutions proposed are working for me.  I tried adding the partition column(loaddate), taking it out, quoting, unquoting, etc.  Still grabs outside of the date range.</p>