创建新的notebook
输入相关参数
jdbcHostname = "-----" jdbcDatabase = "iotdb" userName = 'sa' password = '' jdbcPort = 8433 jdbcUrl = "jdbc:sqlserver://{0}:{1};database={2};user={3};password={4}".format(jdbcHostname, jdbcPort, jdbcDatabase, userName, password) df = spark.read.jdbc(url=jdbcUrl, table='C_BoxStatus') display(df) ----
运行结果