2020年全国省市区街道SQL执行文件
2020年全国省市区街道4层
官网地址:http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2020/index.html
表结构:
CREATE TABLE `city` (
`id` bigint(20) NOT NULL COMMENT '区划代码',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`pid` bigint(20) NULL DEFAULT NULL COMMENT '父级区划代码',
`province_code` bigint(20) NULL DEFAULT NULL COMMENT '省代码',
`city_code` bigint(20) NULL DEFAULT NULL COMMENT '市代码',
`area_code` bigint(20) NULL DEFAULT NULL COMMENT '区代码',
`street_code` bigint(20) NULL DEFAULT NULL COMMENT '街道代码',
`committee_code` bigint(20) NULL DEFAULT NULL COMMENT '居委/社区',
`short_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
`city_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区号',
`lng` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',
`lat` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',
`sort` int(11) NULL DEFAULT NULL COMMENT '排序',
`level` int(4) NULL DEFAULT NULL COMMENT '级别: 0-国家 ,1-省, 2-市, 3-区/县, 4-街/镇',
PRIMARY KEY (`id`) USING BTREE,
INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '全国行政区域表' ROW_FORMAT = DYNAMIC;
carbondata_2.11-1.4.0-SNAPSHOT-shade-hadoop2.7.2.jar
自己亲测可用,官方1.3.0缺少org.apache.spark.sql.hive.CarbonSessionStateBuilder
测试一直就不能通过。
获取截止:2018-3-2号,Github最新源码从新编译解决了找不到类问题
ERROR CarbonProperties: main The specified value for property sort.inmemory.size.inmbis Invalid. Taking the default value.1024
java.lang.ClassNotFoundException: org.apache.spark.sql.hive.CarbonSessionStateBuilder
carbondata-hadoop-1.3.0.jar
CarbonData是一种新的高性能数据存储格式,已在20+企业生产环境上部署和使应用,企业数据规模达到万亿。针对当前大数据领域分析场景需求各异而导致的存储冗余问题,业务驱动下的数据分析灵活性要求越来越高,CarbonData提供了一种新的融合数据存储方案,以一份数据同时支持多种应用场景,并通过多级索引、字典编码、预聚合、动态Partition、准实时数据查询、列存等特性提升了IO扫描和计算性能,实现百亿数据级秒级响应。
carbondata-hadoop-1.3.0-all编译包
Apache CarbonData1.3.0编译包
mvn clean package -DskipTests -Pspark-2.1 -Dspark.version=2.1.0 -Phadoop-2.7.2
[INFO] Reactor Summary:
[INFO]
[INFO] Apache CarbonData :: Parent ........................ SUCCESS [02:54 min]
[INFO] Apache CarbonData :: Common ........................ SUCCESS [01:49 min]
[INFO] Apache CarbonData :: Core .......................... SUCCESS [06:20 min]
[INFO] Apache CarbonData :: Processing .................... SUCCESS [ 51.336 s]
[INFO] Apache CarbonData :: Hadoop ........................ SUCCESS [ 32.951 s]
[INFO] Apache CarbonData :: Spark Common .................. SUCCESS [05:33 min]
[INFO] Apache CarbonData :: Streaming ..................... SUCCESS [01:04 min]
[INFO] Apache CarbonData :: Spark2 ........................ SUCCESS [06:15 min]
[INFO] Apache CarbonData :: Spark Common Test ............. SUCCESS 02:02min]
[INFO] Apache CarbonData :: Assembly ...................... SUCCESS [ 15.719 s]
[INFO] Apache CarbonData :: Hive .......................... SUCCESS [03:17 min]
[INFO] Apache CarbonData :: presto ........................ SUCCESS [06:00 min]
[INFO] Apache CarbonData :: Spark2 Examples ............... SUCCESS [01:19 min]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 38:34 min
[INFO] Finished at: 2018-02-27T23:41:47-08:00
[INFO] Final Memory: 124M/237M
[INFO] ------------------------------------------------------------------------
FlexPLM客制化开发文档
Developing_Client_Side_Plug-ins_in_FlexPLM_6.1.pdf
About This Guide................................................................................................. iii
Using Client Side Plug-ins ................................................................................... 1
What is a Client Side Plug-in? ............................................................................. 1
Introduction .................................................................................................................................... 1
Client Side Plug-in Types .............................................................................................................. 2
Overview ........................................................................................................................................ 3
Justification Guidelines .................................................................................................................. 5
Overview of MainTemplate CSP Architecture ............................................................................... 6
Overview of MainTemplate/Multi-Object Editor CSP Architecture................................................. 9
Creating a Plug-in ............................................................................................... 13
Create the CSP Plug-in....................................................................................... 13
Registering the Plug-in....................................................................................... 14
Acquiring the pagekey ................................................................................................................. 14
Registering the Client Side Plug-in with FlexPLM ................................................................. 16
Developing Client-Side Plug-ins........................................................................ 19
Client Side Plug-in Layout ................................................................................. 20
General Page Layout................................................................................................................... 20
Page Header................................................................................................................................ 20
ClientSidePluginHelper class................................................................................................. 20
handleOnLoadEvent and initPage header............................................................................. 26
handleSubmitEvent header.................................................................................................... 27
handleWidgetEvent header.................................................................................................... 29
Multi-Object Editor Headers................................................................................................... 31
JavaScript Function Generation............................................................................................. 33
Accessing FlexPLM Attribute Type Values .......................................... 40
Attribute Variable Type Widget Definition.................................................................................... 40
Attribute Variable Type Widget Access Examples ...................................................................... 43
Introduction............................................................................................................................. 43
Simple Attribute Variable Type Widget Code Examples........................................................ 44
Complex Attribute Variable Type Widget Code examples..................................................... 46
Multi-Object Tables Editor Page Structure and Use.................................................................... 51
Using Client Side Plug-ins ii
HTML Table Elements............................................................................................................52
TableDataModel ..................................................................................................................... 55
Table Events........................................................................................................................... 58
DOM Table Editor Tools.........................................................................................................63
Development Tips................................................................................................65
Adding CSP Debug statements to Tomcat Console output.............................65
Avoiding Restart of Tomcat during Development of JSPs ..............................69
excel下拉多选实例
excel VB 实现下拉多选功能
jquery easyui实现的Activiti工作流引擎web版流程设计器
jquery easyui实现的Activiti工作流引擎web版流程设计器 跨浏览器流程设计器 打开文件 processDesigner\wf\designer\index.html 即可预览
jbpm-designer-2.4.0.Final-tomcat.war
tomcat7使用成功。将这个下载war包文件重命名为designer.war,丢到tomcat的webapps目录下,启动tomcat访问路径:http://localhost:8080/designer/editor?profile=jbpm