I am new to coding and would like to know where "0" holding the database name in {0}
is supposed to be in this code:
select * , RANK() OVER (ORDER BY CAST(batchid AS INT) DESC) AS RNK FROM {0}.tablename
In python, it is always in the .format(....)
but this is a select statement and this code is part of an urge pyspark code. I couldn't find any .format()
in the code.
The only think I could think of is that at the beginning of the query there is this:
"K4" | "dictionary_name" | "spark" | "with cte as
aselect...... + 813 lines of codes then
" | "pulls the data from databasename on batchid condition"
Could "K4" I "dictionary_name" I be the elements that passed as {0} and {1} ???
question from:
https://stackoverflow.com/questions/65860378/placeholders-in-a-from-clause-in-sql-query-like-in-python-string-formating 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…