Had the same error. You have to run appbuilder.init_app() for your app:

..
..
class RubyAPP(object):
    def __init__(self, config_name):
        # App manager
        app.config.from_pyfile('config.py')
        db.init_app(app)

        with app.app_context():
            appbuilder.init_app(app, db.session)
..
..

SparkSession is not a replacement for a SparkContext but an equivalent of the SQLContext. Just use it use the same way as you used to use SQLContext:

spark.createDataFrame(...)

and if you ever have to access SparkContext use sparkContext attribute:

spark.sparkContext

so if you need SQLContext for backwards compatibility you can:

SQLContext(sparkContext=spark.sparkContext, sparkSession=spark)

As I'm not getting much help with my original question I did some research and rewrote the pyspark.sql query as follows:

#%%
import findspark
findspark.init('/home/packt/spark-2.1.0-bin-hadoop2.7')
from pyspark.sql import SparkSession
spark = SparkSession.builder.appName('ops').getOrCreate()
df = spark.read.csv('/home/packt/Downloads/Spark_DataFrames/Person_Person.csv',inferSchema=True,header=True)
df.createOrReplaceTempView('Person_Person')
myresults = spark.sql("""SELECT
PersonType
,COUNT(PersonType) AS \Person Count`FROM Person_PersonGROUP BY PersonType""")myresults.collect()result = myresults.collect()resultresult.saveAsTextFile("test")`

However, I'm now getting the following error message:

AttributeError Traceback (most recent call last) <ipython-input-9-9e137ed161cc> in <module>() ----> 1 result.saveAsTextFile("test") AttributeError: 'list' object has no attribute 'saveAsTextFile'

Hopefully, this will get more responses to help me fix this issue

Thanks

Your indentation is goofed, and you've mixed tabs and spaces. Run the script with python -tt to verify.

In new_mmqgis.py:

You set self.first_start = True in initGui, then, you set self.first_start = False in run method. In geocode_web_service method, you are checking if self.first_start == True. That if block never runs because self.first_start=False. That is the reason of getting 'NewMmqgis' object has no attribute 'dlg2' error.

One solution to this would be to remove the following two lines and unindent the third one in geocode_web_service method.

if self.first_start == True: # REMOVE
    self.first_start = False # REMOVE

<-  self.dlg2 = mmqgis_geocode_web_service_dialog() # UNINDENT

For the second error, you probably didn't add a status bar named status. Check new_mmqgis_dialog_base.ui file.