Azure Databricks: leading zeros in decimal integer literals are not permitted

gopikrsna925 — Fri, 28 Jul 2023 15:40:34 GMT

Hey team,

Need your help.

I am trying to run the below python code in a data bricks notebook, which is part of parsing an XML file, exploding the element. This works great for all the other elements with no numbers and elements not starting with a zero but anything that starts with a 0 in the second part of the string is where it's failing.

Code:
56:.withColumn('OcrnInfo_Bond-102005', explode_outer(col('OcrnInfo').Bond-102005)) \

57:.withColumn('OcrnInfo_Bond-052009', explode_outer(col('OcrnInfo').Bond-052009)) \

Error:

leading zeros in decimal integer literals are not permitted; use an 0o prefix for octal integers (, line 57)

.withColumn('OcrnInfo_Bond-052009', explode_outer(col('OcrnInfo').Bond-052009)) \

^
Bond-052009 is a structfield in XML definition of arraytype which in turn has a structype for the attributes it holds. I have tried single/double quotes, all sorts of brackets around the string but just keeps failing with the same error. If I delete this line it fails on the next one which is Bnkrpt-052009 so definitely the second part of the string is failing. I am unable to change these names.

Any advice is greatly appreciated.

topic Azure Databricks: leading zeros in decimal integer literals are not permitted in Data Engineering

Azure Databricks: leading zeros in decimal integer literals are not permitted