09 2020 档案
摘要:select regexp_replace(lg,'\\n|\\r|\\t|\\s+','') from spd_trancare_mid.mapping_lg_desc
阅读全文
摘要:20200915:利用远程mysql创建表时出现报错。 CREATE TABLE test.test_perm ENGINE = MergeTree() ORDER BY app_id AS SELECT * FROM mysql('10.32.0.103:3306', 'test', 'test_
阅读全文
摘要:MYSQL select * from mysql('10.32.0.103:3306','test','t1','trancare','trancare'); 从MYSQL创建表 create table test.t2 ENGINE=TinyLog() as select * from mysq
阅读全文
摘要:from pyspark.sql import SparkSession from pyspark.conf import SparkConf from pyspark.sql import SQLContext conf = SparkConf().setAppName('数据总览') spark
阅读全文
摘要:print(spark.sql('set -v').collect())
阅读全文