我正試圖在azure數據塊內的python筆記本中運行以下查詢
tab ='db.t1'
df =spark.sql(f"SELECT MAX(_commit_version) as max_version FROM table_changes({tab},0)")
df.first()["max_version"]
但它拋出的錯誤如下
AnalysisException: [UNRESOLVED_COLUMN.WITHOUT_SUGGESTION] A column or function parameter with name `t1` cannot be resolved. ; line 1 pos 62;
'Project ['MAX('_commit_version) AS max_version#5374]
+- 'UnresolvedTableValuedFunction [table_changes], ['db.t1, 0]
有人能幫我嗎
表名稱參數應在引號中（請參閱文檔）。嘗試：