title: pyspark Join multiple Dataframes
body: <p>I am new in the spark and big data world.
  I transferred my MySQL database to HDFS with some airflow DAGs and now every table is a parquet file in HDFS now I need to convert blew query to pyspark over dataframes.</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT PV.id product_id,
         ZP.vendor_id vendor_id,
         V.title vendor_name,
         PV.barcode barcode,
         PV.title product_title,
         ZP.active product_active,
         ZP.price product_price,
         ZP.capacity product_capacity,
         ZP.stock product_stock,
         MC1.title subcat_title,
         MC2.title parent_category_title,
         ZB.title brand_name
  FROM xpediaProductVariationVendorInfo ZP
  JOIN ProductVariations PV ON PV.id = ZP.xpediaProductVariation_id
  JOIN Vendors V ON ZP.vendor_id = V.id
  JOIN VendorTypes vt ON V.vendor_type_id = vt.id
  JOIN xpediaProductVariation ZPV ON ZPV.id = PV.id
  JOIN MenuCategories MC1 ON PV.menu_category_id = MC1.id
  LEFT JOIN MenuCategories MC2 ON MC1.parent_id = MC2.id
  LEFT JOIN xpedia_brand ZB ON ZB.id = ZPV.brand_id
  WHERE ZP.vendor_id={}
    AND V.status not in ('Suspend')
  GROUP BY PV.id,
           ZP.vendor_id;      
  </code></pre>