<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ rootadoname | tolower() ] failed in the evaluation of <p> Apache Spark ???????????????????????????[company_name] JDBC Driver for [service] ?????????Spark ???????[service] ?????????????????????Spark ????????[service] ?????????????????? </p> <p> [company_name] JDBC Driver ?????????????????????????????????????[service] ????????????????????????[service] ????SQL ???????????????????????????????????SQL?????[service] ??????????SQL ?????????????????????(SQL ???JOIN ??)???????????????????????????????????????????????????[service] ???????????? </p> <h2>[company_name] JDBC Driver for [service] ???????</h2> <p> [company_name] JDBC Driver for [service] ?????????????????????????JAR ????????????????????????? </p> <h2>Spark Shell ?????[service] ??????</h2> <ol> <li>?????????Spark shell ?[company_name] JDBC Driver for [service] JAR file ?<var>jars</var> ???????????: <code> $ spark-shell --jars /[company_name]/[company_name] JDBC Driver for [service]/lib/[company_name|tolower].jdbc.[rootadoname|tolower].jar </code> </li> <li>Shell ?JDBC URL ????[service] ?????SQL Context <var>load()</var> function ????????????? [extraconnectionnotesjdbc|def('[extraconnectionnotes|def("")]')] <h4>???????????????</h4> <p>JDBC ?????URL ??????[service] JDBC Driver ?????????????????????JAR ????????????????????????JAR ????????????????????</p> <code> java -jar cdata.jdbc.[rootadoname|tolower].jar </code> <p> ????????????????????????????????? </p> <code> scala> val [rootadoname|tolower]_df = spark.sqlContext.read.format("jdbc").option("url", "jdbc:[rootadoname|tolower]:[extraconnectionprops]").option("dbtable","[extable]").option("driver","[company_name|tolower].jdbc.[rootadoname|tolower].[rootadoname]Driver").load() </code></li> <li>???????????????????????????????????</li> <li><p>[service] ???????????????????:</p> <code>scala> [rootadoname|tolower]_df.registerTable("[extable|tolower]")</code> </li> <li> <p>?????????????????SQL ?????????:</p> <code>scala> [rootadoname|tolower]_df.sqlContext.sql("SELECT [excol#1], [excol#2] FROM [extable] WHERE [exselectwherecol] = [exselectwherecolequals]").collect.foreach(println)</code> <p>You will see the results displayed in the console, similar to the following:</p> <img src="[x|UrlRootAbs]/kb/articles/jdbc-apache-spark-1.png" title="[datatype] in Apache Spark (Salesforce is shown)" /> </li> </ol> <p> [company_name] JDBC Driver for [service] ?Apache Spark ?????[service] ?????????????????????????????????<a href="../../jdbc">30???????</a> ????????????????? </p>. The error was: The attribute does not exist. This formatter cannot be called with nonexistent attributes.<br><b>URL</b>: /jp/kb/tech/adp-jdbc-apache-spark.rst