sqoop1.99.6 mysql_[sqoop1.99.6] 基于1.99.6版本的一个小例子

最新推荐文章于 2021-02-11 11:03:27 发布
最新推荐文章于 2021-02-11 11:03:27 发布
阅读量97 收藏
点赞数
文章标签： sqoop1.99.6 mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_36062835/article/details/113543131
版权

1、创建mysql数据库、表、以及测试数据

mysql> desc test;

+-------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | varchar(45) | YES | | NULL | |

| age | int(11) | YES | | NULL | |

+-------+-------------+------+-----+---------+----------------+

2、赋予权限

grant all on test.* to 'root@localhost' identified by 'root';

flush privileges;

grant all on saiku_base.* to 'root@localhost' identified by 'password';

flush privileges;

3、启动sqoop2-server

./bin/sqoop2-server start

4、启动sqoop2-shell

./bin/sqoop2-shell

5、查看连接信息

sqoop:000> show connector

+----+------------------------+---------+------------------------------------------------------+----------------------+

| Id | Name | Version | Class | Supported Directions |

+----+------------------------+---------+------------------------------------------------------+----------------------+

| 1 | generic-jdbc-connector | 1.99.6 | org.apache.sqoop.connector.jdbc.GenericJdbcConnector | FROM/TO |

| 2 | kite-connector | 1.99.6 | org.apache.sqoop.connector.kite.KiteConnector | FROM/TO |

| 3 | hdfs-connector | 1.99.6 | org.apache.sqoop.connector.hdfs.HdfsConnector | FROM/TO |

| 4 | kafka-connector | 1.99.6 | org.apache.sqoop.connector.kafka.KafkaConnector | TO |

+----+------------------------+---------+------------------------------------------------------+----------------------+

第1种 传统jdbc连接

第3种 hdfs连接

6、创建一个传统的jdbc连接

sqoop:000> create link -c 1 (这里的数字1是connector的类型 也就是代指传统jdbc连接)

Name:192.168.200.70-mysql

JDBC Driver Class: com.mysql.jdbc.Driver

JDBC Connection String: jdbc:mysql://192.168.200.70:3306/saiku_base?useUnicode=true&characterEncoding=utf-8

Username: root

Password: password

JDBC Connection Properties:

There are currently 0 values in the map:

entry#

New link was successfully created with validation status OK and persistent id 1

7、查看创建的jdbc连接

sqoop:000> show link

+----+---------------------+--------------+------------------------+---------+

| Id | Name | Connector Id | Connector Name | Enabled |

+----+---------------------+--------------+------------------------+---------+

| 1 | 192.168.10.52-mysql | 1 | generic-jdbc-connector | true |

+----+---------------------+--------------+------------------------+---------+

修改link：update link -l 1

删除link：delete link -l 1

8、创建一个HDFS连接

语法：http://sqoop.apache.org/docs/1.99.6/CommandLineClient.html#delete-link-function

HDFS URI 例子：

hdfs://example.com:8020/

hdfs://example.com/

file:///

file:///tmp

file://localhost/tmp

sqoop:000> create link -c 3

Creating link for connector with id 3

Please fill following values to create new link object

Name: 1921.68.200.70-hdfs

Link configuration

HDFS URI: hdfs://namenode:9000

Hadoop conf directory: /home/hadoop/hadoop/etc/hadoop

New link was successfully created with validation status OK and persistent id 3

9、查看创建的hdfs连接

sqoop:000> show link

+----+---------------------+--------------+------------------------+---------+

| Id | Name | Connector Id | Connector Name | Enabled |

+----+---------------------+--------------+------------------------+---------+

| 1 | 192.168.10.52-mysql | 1 | generic-jdbc-connector | true |

| 3 | 1921.68.200.70-hdfs | 3 | hdfs-connector | true |

+----+---------------------+--------------+------------------------+---------+

这时候，mysql和hdfs的连接就创建完毕了

接下来要执行数据同步操作

10、创建job -f【from】 -t【to】 即从哪一个数据库导入到另一个数据库

sqoop:000> show link

+----+---------------------+--------------+------------------------+---------+

| Id | Name | Connector Id | Connector Name | Enabled |

+----+---------------------+--------------+------------------------+---------+

| 1 | 192.168.10.52-mysql | 1 | generic-jdbc-connector | true |

| 3 | 1921.68.200.70-hdfs | 3 | hdfs-connector | true |

+----+---------------------+--------------+------------------------+---------+

sqoop:000> create job -f 1 -t 3 【将数据从mysql同步到hdfs】

Creating job for links with from id 1 and to id 3

Please fill following values to create new job object

Name: sync_mysql_2_hdfs

From database configuration

Schema name: test

Table name: test

Table SQL statement:

Table column names:

Partition column name:

Null value allowed for the partition column:

Boundary query:

Incremental read

Check column:

Last value:

To HDFS configuration

Override null value:

Null value:

Output format:

0 : TEXT_FILE

1 : SEQUENCE_FILE

Choose: 0

Compression format:

0 : NONE

1 : DEFAULT

2 : DEFLATE

3 : GZIP

4 : BZIP2

5 : LZO

6 : LZ4

7 : SNAPPY

8 : CUSTOM

Choose: 0

Custom compression format:

Output directory: hdfs://master:9000/sqoop2/tbl_test_from_mysql_2_hdfs

Append mode:

Throttling resources

Extractors:

Loaders:

New job was successfully created with validation status OK and persistent id 1

11、查看job

sqoop:000> show job

+----+-------------------+----------------+--------------+---------+

| Id | Name | From Connector | To Connector | Enabled |

+----+-------------------+----------------+--------------+---------+

| 1 | sync_mysql_2_hdfs | 1 | 3 | true |

+----+-------------------+----------------+--------------+---------+

12、启动指定的job: 该job执行完后查看HDFS上的文件 hdfs://master:9000/sqoop2/tbl_test_from_mysql_2_hdfs

sqoop:000> start job --jid 1

Exception has occurred during processing command

Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server has returned exception

在start job(如：start job --jid 2)时常见错误：

Exception has occurred during processing command

Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server has returned exception

在sqoop客户端设置查看job详情：

set option --name verbose --value true

show job --jid 2

例如：

sqoop:000> set option --name verbose --value true

Verbose option was changed to true

sqoop:000> show job -jid 1

1 job(s) to show:

Job with id 1 and name sync_mysql_2_hdfs (Enabled: true, Created by hadoop at 16-2-19 下午3:47, Updated by hadoop at 16-2-19 下午3:47)

Throttling resources

Extractors:

Loaders:

From link: 1

From database configuration

Schema name: test

Table name: test

Table SQL statement:

Table column names:

Partition column name:

Null value allowed for the partition column:

Boundary query:

Incremental read

Check column:

Last value:

To link: 3

To HDFS configuration

Override null value:

Null value:

Output format: TEXT_FILE

Compression format: NONE

Custom compression format:

Output directory: hdfs://master:9000/sqoop2/tbl_test_from_mysql_2_hdfs

Append mode:

然后再次启动任务就可以显示出有用的出错信息

sqoop:000> start job --jid 1

Exception has occurred during processing command

Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server has returned exception

Stack trace:

at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:129)

at org.apache.sqoop.client.request.ResourceRequest (ResourceRequest.java:179)

at org.apache.sqoop.client.request.JobResourceRequest (JobResourceRequest.java:112)

at org.apache.sqoop.client.request.SqoopResourceRequests (SqoopResourceRequests.java:157)

at org.apache.sqoop.client.SqoopClient (SqoopClient.java:452)

at org.apache.sqoop.shell.StartJobFunction (StartJobFunction.java:80)

at org.apache.sqoop.shell.SqoopFunction (SqoopFunction.java:51)

at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:135)

at org.apache.sqoop.shell.SqoopCommand (SqoopCommand.java:111)

at org.codehaus.groovy.tools.shell.Command$execute (null:-1)

at org.codehaus.groovy.tools.shell.Shell (Shell.groovy:101)

at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:-1)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method (Method.java:497)

at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)

at groovy.lang.MetaMethod (MetaMethod.java:233)

at groovy.lang.MetaClassImpl (MetaClassImpl.java:1054)

at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:128)

at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:173)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method (Method.java:497)

at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce (PogoMetaMethodSite.java:267)

at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite (PogoMetaMethodSite.java:52)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:141)

at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:121)

at org.codehaus.groovy.tools.shell.Shell (Shell.groovy:114)

at org.codehaus.groovy.tools.shell.Shell$leftShift$0 (null:-1)

at org.codehaus.groovy.tools.shell.ShellRunner (ShellRunner.groovy:88)

at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:-1)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method (Method.java:497)

at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)

at groovy.lang.MetaMethod (MetaMethod.java:233)

at groovy.lang.MetaClassImpl (MetaClassImpl.java:1054)

at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:128)

at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:148)

at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:100)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method (Method.java:497)

at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSiteNoUnwrapNoCoerce (PogoMetaMethodSite.java:267)

at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite (PogoMetaMethodSite.java:52)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:137)

at org.codehaus.groovy.tools.shell.ShellRunner (ShellRunner.groovy:57)

at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:-1)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:-2)

at sun.reflect.NativeMethodAccessorImpl (NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl (DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method (Method.java:497)

at org.codehaus.groovy.reflection.CachedMethod (CachedMethod.java:90)

at groovy.lang.MetaMethod (MetaMethod.java:233)

at groovy.lang.MetaClassImpl (MetaClassImpl.java:1054)

at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:128)

at org.codehaus.groovy.runtime.ScriptBytecodeAdapter (ScriptBytecodeAdapter.java:148)

at org.codehaus.groovy.tools.shell.InteractiveShellRunner (InteractiveShellRunner.groovy:66)

at java_lang_Runnable$run (null:-1)

at org.codehaus.groovy.runtime.callsite.CallSiteArray (CallSiteArray.java:42)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:108)

at org.codehaus.groovy.runtime.callsite.AbstractCallSite (AbstractCallSite.java:112)

at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:463)

at org.codehaus.groovy.tools.shell.Groovysh (Groovysh.groovy:402)

at org.apache.sqoop.shell.SqoopShell (SqoopShell.java:130)

Caused by: Exception: java.lang.IllegalArgumentException Message: Wrong FS: hdfs://master:9000/sqoop2/tbl_test_from_mysql_2_hdfs, expected: hdfs://namenode:9000

Stack trace:

at org.apache.hadoop.fs.FileSystem (FileSystem.java:646)

at org.apache.hadoop.hdfs.DistributedFileSystem (DistributedFileSystem.java:194)

at org.apache.hadoop.hdfs.DistributedFileSystem (DistributedFileSystem.java:106)

at org.apache.hadoop.hdfs.DistributedFileSystem$22 (DistributedFileSystem.java:1305)

at org.apache.hadoop.hdfs.DistributedFileSystem$22 (DistributedFileSystem.java:1301)

at org.apache.hadoop.fs.FileSystemLinkResolver (FileSystemLinkResolver.java:81)

at org.apache.hadoop.hdfs.DistributedFileSystem (DistributedFileSystem.java:1301)

at org.apache.hadoop.fs.FileSystem (FileSystem.java:1424)

at org.apache.sqoop.connector.hdfs.HdfsToInitializer (HdfsToInitializer.java:58)

at org.apache.sqoop.connector.hdfs.HdfsToInitializer (HdfsToInitializer.java:35)

at org.apache.sqoop.driver.JobManager (JobManager.java:449)

at org.apache.sqoop.driver.JobManager (JobManager.java:373)

at org.apache.sqoop.driver.JobManager (JobManager.java:276)

at org.apache.sqoop.handler.JobRequestHandler (JobRequestHandler.java:380)

at org.apache.sqoop.handler.JobRequestHandler (JobRequestHandler.java:116)

at org.apache.sqoop.server.v1.JobServlet (JobServlet.java:96)

at org.apache.sqoop.server.SqoopProtocolServlet (SqoopProtocolServlet.java:79)

at javax.servlet.http.HttpServlet (HttpServlet.java:646)

at javax.servlet.http.HttpServlet (HttpServlet.java:723)

at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:206)

at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:595)

at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter (DelegationTokenAuthenticationFilter.java:291)

at org.apache.hadoop.security.authentication.server.AuthenticationFilter (AuthenticationFilter.java:554)

at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain (ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve (StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve (StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve (StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve (ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve (StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter (CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11Processor (Http11Processor.java:861)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler (Http11Protocol.java:606)

at org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:489)

at java.lang.Thread (Thread.java:745)

sqoop:000>

出错原因：

Caused by: Exception: java.lang.IllegalArgumentException Message: Wrong FS: hdfs://master:9000/sqoop2/tbl_test_from_mysql_2_hdfs, expected: hdfs://namenode:9000

创建 link 的时候 HDFS URL错了 不是 hdfs://namenode:9000 是hdfs://master:9000

修改

update job -jid 1

Output directory: hdfs://namenode:9000/sqoop2/tbl_test_from_mysql_2_hdfs

日志：

sqoop:000> start job --jid 1

Submission details

Job ID: 1

Server URL: http://localhost:12000/sqoop/

Created by: hadoop

Creation date: 2016-02-19 16:04:59 CST

Lastly updated by: hadoop

External ID: job_1455853781605_0001

http://namenode:8088/proxy/application_1455853781605_0001/

Source Connector schema: Schema{name=test.test,columns=[

FixedPoint{name=id,nullable=true,type=FIXED_POINT,byteSize=4,signed=true},

Text{name=name,nullable=true,type=TEXT,charSize=null},

FixedPoint{name=age,nullable=true,type=FIXED_POINT,byteSize=4,signed=true}]}

2016-02-19 16:04:59 CST: BOOTING - Progress is not available

#查看任务执行状态

sqoop:000> status job --jid 1

Submission details

Job ID: 1

Server URL: http://localhost:12000/sqoop/

Created by: hadoop

Creation date: 2016-02-19 16:04:59 CST

Lastly updated by: hadoop

External ID: job_1455853781605_0001

http://namenode:8088/proxy/application_1455853781605_0001/

2016-02-19 16:07:26 CST: BOOTING - 0.00 %

解释：http://sqoop.apache.org/docs/1.99.2/ClientAPI.html

Job submission requires a job id. On successful submission, getStatus() method returns “BOOTING” or “RUNNING”.

sqoop:000> show submission

+--------+------------------------+---------+------------------------------+

| Job Id | External Id | Status | Last Update Date |

+--------+------------------------+---------+------------------------------+

| 1 | job_1455853781605_0001 | BOOTING | Fri Feb 19 16:15:22 CST 2016 |

+--------+------------------------+---------+------------------------------+

吴成芳
关注
Sqoop2的安装与使用
Lucius的专栏
07-14 1万+
Installation Sqoop ships as one binary package however it’s compound from two separate parts - client and server. You need to install server on single node in your cluster. This node will then serv
MySQL 日期时间分区问题
平时的经验总结，学习历程
05-14 5198
Field 'start_time' is of a not allowed type for this type of partitioning VALUES value for partition 'p202204' must have type INT The PARTITION function returns the wrong type Constant, random or timezone-dependent expressions in (sub)partitioning function
sqoop2
weixin_37796929的博客
05-08 262
sqoop:000> start job --jid 3 Exception has occurred during processing command Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server has returned exception - Apache Tomcat/6....
sqoop1.99.6 mysql_Sqoop 1.99.6 安装和使用
weixin_42502933的博客
01-19 209
安装1.安装准备工作：下载的sqoop安装包http://mirrors.hust.edu.cn/apache/sqoop/1.99.6/sqoop-1.99.6.tar.gz2.解压文件到工作目录:hadoop@hadoopMaster:$ sudo tar -xvf /opt/hn/hadoop_family/sqoop-1.99.6-bin-hadoop200.tar.gzhadoop@ha...
[sqoop1.99.6] 基于1.99.6版本的一个小例子
weixin_34100227的博客
12-19 61
1、创建mysql数据库、表、以及测试数据mysql> desc test;+-------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-------+-------------+------+---...
Sqoop 1.99.6 安装和使用
06-24 137
安装 1.安装准备工作： 下载的sqoop安装包 http://mirrors.hust.edu.cn/apache/sqoop/1.99.6/sqoop-1.99.6.tar.gz 2.解压文件到工作目录: hadoop@hadoopMaster:$ sudo tar -xvf /opt/hn/hadoop_family/sqoop-1.99....
sqoop的java操作，总结归纳，含代码
热门推荐
u011856283的博客
06-14 1万+
（下面说的操作hdfs其实和操作hive意思一样，都是文件夹）最近要在项目中加一个sqoop的功能，需求是将hive的数据导入至mysql，也就是export功能由于之前没用过sqoop，所以特地去学习怎么使用，这里总结下这两天了解到的简单内容首先sqoop有两个版本，1.4.X和1.99.X，前者俗称为sqoop1后者成为sqoop2，然后又有apache和cloudera两种sqoop1和sq...
hadoop搭建 zookeeper_hbase_hive_sqoop_mysql_spark_hdfs.doc
10-20
在构建一个完整的Hadoop生态系统时，我们需要搭建多个组件，包括Zookeeper、HBase、Hive、MySQL、Kafka以及Spark，并且它们都要运行在HDFS之上。下面将详细介绍这些组件的安装与配置过程。 1. **Zookeeper**： ...
MySqoop_Sqoop脚本生成_sqoop脚本_
09-30
Sqoop是一款用于在Apache Hadoop和关系型数据库之间进行数据导入导出的工具。它提供了命令行接口，允许用户方便地将数据导入到Hadoop的HDFS，或者从HDFS导出到关系型数据库。本篇文章将详细讲解 Sqoop 脚本生成的...
sqoop连接mysql_Sqoop jdbc 连接 MySQL 驱动包com.mysql.cj.jdbc.Driver 问题解决方法
weixin_35712811的博客
01-19 1068
Sqloop 通过jdbc 连接Mysql数据库，提示驱动过期，如下：https://www.cndba.cn/dave/article/3302https://www.cndba.cn/dave/article/3302[dave@www.cndba.cn lib]$ sqoop list-databases --connect jdbc:mysql://192.168.56.2:3306/ -...
sqoop blob mysql_sqoop系列-sqoop MySQL 导入Hive JSON 字段乱码
weixin_31572189的博客
02-11 342
问题简介最近业务方反馈依照导入MySQL表导入Hive有部分字段变更乱码，于是乎走上了解决乱码的不归路。集群信息服务器系统版本：centos 7.2cdh 版本：cdh5.9.0hadoop 版本：2.6.0+cdh5.9.0hive 版本：1.1.0+cdh5.9.0sqoop 版本：1.4.6+cdh5.9.0备注：涉及敏感信息的的变量，使用${xxxx} 代替问题定位首先，导入乱码想都不用想...
三相异步电机矢量控制仿真模型
10-08
三相异步电机矢量控制仿真模型
C++ 电力塔倾斜检测算法代码+点云测试数据
10-08
算法步骤1. 加载点云；2.坐标归一化；3. 杆塔高度分层；4.计算分层质心点坐标；5.质心点归一化；6. 中心直线拟合；7.计算杆塔倾角；8.计算杆塔偏移距离；9.输出中心直线点云文件。
两级式单相光伏并网仿真（注意版本matlab 2021a） 前级采用DC-DC变电路，通过MPPT控制DC-DC电路的pwm波来
10-08
两级式单相光伏并网仿真（注意版本matlab 2021a） 前级采用DC-DC变电路，通过MPPT控制DC-DC电路的pwm波来实现最大功率跟踪,mppt采用扰动观察法，后级采用桥式逆变，用spwm波调制。 采用双闭环控制，实现直流母线电压的稳定和单位功率因数。 并网效果良好，thd满足并网要求，附带仿真说明文件
基于 OpenCV打包以并行读取多个 rtsp 相机
10-08
rtsp-多捕获器 打包以读取多台相机，它们之间没有延迟。基于 OpenCV。 特征： 异步捕获 rtsp 流或网络摄像头， 可调帧率 / 自动重新连接。 安装 请确保您已安装 python 3.8 或更高版本。 创建虚拟环境 在控制台上，导航到项目文件夹并执行以下操作： mkdir venv python3 -m venv ./venv source ./venv/bin/activate 您应该会在终端中看到一个 （venv）。 安装依赖项 项目的依赖项在 requirements.txt 文件中列出。要安装它们，请执行以下操作： pip3 install -r requirements.txt 就是这样！ 运行项目 要运行该项目，请确保您已激活虚拟环境并执行以下操作： python3 app.py 0 --fps 1
基于Transformer-SVM的数据多输入单输出回归预测（Matlab完整源码和数据）
最新发布
10-08
1.Matlab基于Transformer-SVM的数据多输入单输出回归预测（完整源码和数据）（完整源码和数据） 2.多特征输入单输出的回归预测。程序内注释详细，csv数据，直接替换数据就可以用。 3.程序语言为matlab，程序可出预测效果图，运行环境matlab2023b及以上。评价指标包括:R2、MSE、RMSE、MAE、MAPE等。 4.代码特点：参数化编程、参数可方便更改、代码编程思路清晰。 5.适用对象：计算机，电子信息工程、数学等专业的大学生课程设计、期末大作业和毕业设计。 6.作者介绍：机器学习之心，博客专家认证，机器学习领域创作者，2023博客之星TOP50，主做机器学习和深度学习时序、回归、分类、聚类和降维等程序设计和案例分析，文章底部有博主联系方式。从事Matlab、Python算法仿真工作8年，更多仿真源码、数据集定制私信。
hdfs mysql sqoop 失败_sqoop从mysql导入数据到hdfs出错
06-10
您好，可能出现sqoop从MySQL导入数据到HDFS失败的原因有很多，可以尝试以下几个步骤来排除问题： 1. 确认MySQL数据库的连接信息是否正确，例如用户名、密码、主机名、端口号等。 2. 确认Hadoop集群的配置是否正确，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值