Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Getting ParseException in importing views #169

Open
shivmrstogi opened this issue Apr 28, 2022 · 0 comments
Open

Getting ParseException in importing views #169

shivmrstogi opened this issue Apr 28, 2022 · 0 comments

Comments

@shivmrstogi
Copy link

shivmrstogi commented Apr 28, 2022

Were are facing the below mentioned error while importing views-

2022-04-26,04:56:05;INFO;Importing view enriched_historical_sap_ariba.commoditydim_bdm_sampleview 2022-04-26,04:56:05;ERROR;ParseException: 2022-04-26,04:56:05;ERROR;{"resultType": "error", "summary": "<span class="ansi-red-fg">ParseException: ", "cause": "---------------------------------------------------------------------------\nParseException Traceback (most recent call last)\n in \n 5 'transient_lastDdlTime' = '1650896575')\n 6 AS Select categoryidl1, timecreated From commoditydim_bdm\n----> 7 LOCATION 'abfss://[email protected]/sap_ariba/historical/commoditydim_bdm_sampleview' """)\n\n/databricks/spark/python/pyspark/sql/session.py in sql(self, sqlQuery)\n 707 [Row(f1=1, f2=u'row1'), Row(f1=2, f2=u'row2'), Row(f1=3, f2=u'row3')]\n 708 """\n--> 709 return DataFrame(self._jsparkSession.sql(sqlQuery), self._wrapped)\n 710 \n 711 @SInCE(2.0)\n\n/databricks/spark/python/lib/py4j-0.10.9-src.zip/py4j/java_gateway.py in call(self, *args)\n 1303 answer = self.gateway_client.send_command(command)\n 1304 return_value = get_return_value(\n-> 1305 answer, self.gateway_client, self.target_id, [self.name](?\n 1306 \n 1307 for temp_arg in temp_args:\n\n/databricks/spark/python/pyspark/sql/utils.py in deco(*a, **kw)\n 131 # Hide where the exception came from that shows a non-Pythonic\n 132 # JVM exception message.\n--> 133 raise_from(converted)\n 134 else:\n 135 raise\n\n/databricks/spark/python/pyspark/sql/utils.py in raise_from(e)\n\nParseException: \nextraneous input ''abfss://[email protected]/sap_ariba/historical/commoditydim_bdm_sampleview'' expecting {, ';'}(line 7, pos 9)\n\n== SQL ==\n CREATE VIEW enriched_historical_sap_ariba.commoditydim_bdm_sampleview (\n categoryidl1,\n timecreated)\nTBLPROPERTIES (\n 'transient_lastDdlTime' = '1650896575')\nAS Select categoryidl1, timecreated From commoditydim_bdm\nLOCATION 'abfss://[email protected]/sap_ariba/historical/commoditydim_bdm_sampleview' \n---------^^^"} 2022-04-26,04:56:05;INFO;{'resultType': 'error', 'summary': 'ParseException: ', 'cause': '---------------------------------------------------------------------------\nParseException Traceback (most recent call last)\n in \n 5 'transient_lastDdlTime' = '1650896575')\n 6 AS Select categoryidl1, timecreated From commoditydim_bdm\n----> 7 LOCATION 'abfss://[[email protected]/sap_ariba/historical/commoditydim_bdm_sampleview](https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fenriched-internal%40zneudh3n14enrdcurd01.dfs.core.windows.net%2%3D&reserved=0)' """)\n\n/databricks/spark/python/pyspark/sql/session.py in sql(self, sqlQuery)\n 707 [Row(f1=1, f2=u'row1'), Row(f1=2, f2=u'row2'), Row(f1=3, f2=u'row3')]\n 708 """\n--> 709 return DataFrame(self._jsparkSession.sql(sqlQuery), self._wrapped)\n 710 \n 711 @SInCE(2.0)\n\n/databricks/spark/python/lib/py4j-0.10.9-src.zip/py4j/java_gateway.py in call(self, *args)\n 1303 answer = self.gateway_client.send_command(command)\n 1304 return_value = get_return_value(\n-> 1305 answer, self.gateway_client, self.target_id, [self.name](https://eur03.safelinks.protection.outlook.com/?\n 1306 \n 1307 for temp_arg in temp_args:\n\n/databricks/spark/python/pyspark/sql/utils.py in deco(*a, **kw)\n 131 # Hide where the exception came from that shows a non-Pythonic\n 132 # JVM exception message.\n--> 133 raise_from(converted)\n 134 else:\n 135 raise\n\n/databricks/spark/python/pyspark/sql/utils.py in raise_from(e)\n\nParseException: \nextraneous input ''abfss://
Can someone please help on this one?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant