I am using spark SQL in pyspark for some SQL query in MYSQL DB:

output = scSpark.sql('SELECT Categories AS type, `Course Material Title` AS title, `Author/Editor` AS author, `iSBN` AS isbn,  `Publication Year` AS pub_date, `edition` AS edition, `e-iSBN / VBID` AS vbid,  `Distribution Mode` AS Distribution_platform FROM books LIMIT 1 OFFSET 1')

I got the error when using this SQL query:
pyspark.sql.utils.ParseException:
mismatched input ‘OFFSET’ expecting {, ‘;’}(line 1, pos 249)

How could I fix this error?