talend scenarios

permission to access the data table1143: The current user does not have permission to access fields in the datasheet1146: Data table does not exist1147: User access to the data table is undefined1149:sql statement Syntax error1158: Network error, read error, please check network connection status1159: Network error, read timeout, check network connection status1160: Network error, write error, please check network connection status1161: Network error, write timeout, please check network connect

The process of solving the problem is as follows:1, encountered the problem and the general solution is the same as the following post:http://www.oschina.net/question/188964_323052, I in accordance with the practice of 1 after configuration, still can not find the driver. So continue to find, see the following this post:http://haohaoxuexi.iteye.com/blog/1843309There are two key points in it: Note: due to the use of the Sqlsessionfactory and Sqlsessiontemplate properties, some content will be loa

Label:1. If there is an or in the condition, it will not be used even if there is a conditional index (which is why the use of or is minimized);2. For multi-column indexes, not the first part of the use, the index is not used;3.like queries are preceded by%;4. If the column type is a string, be sure to use quotation marks in the condition to reference the data, otherwise do not use the index;5. If MySQL estimates that using a full table scan is faster than using an index, the index is not used;A

Label:php5.6 If you want to connect to a SQL Server 2008 database, you need to manually configure the extension and install a driver. Download SQL Server Driver for PHP extension pack, 64-bit system is not officially supported, find an unofficial: Http://pan.baidu.com/s/1o7FVblw Unzip copy inside DLL file into PHP ext folder inside Open a php.ini file to add the following two extensions: Extension=php_pdo_sqlsrv_56_ts. dll extension=php_sqlsrv_56_ts.dll Restart Apache after saving php.ini. Vie

Tags: rdb XML sync view href objects ACL app typeDatabase synchronization Scenario 1. Export the first 500 rows of data per table using a data pumpEXPDP tvpay2/tvpay directory=dmp dumpfile=20170508.dmp include=table query= "' Where rownum Note: There are restrictions on the first few lines of each table using exp import Exp Tvpay2/tvpay file=t.dmp tables= (EMP,EMP1) query= "' Where rownum Query all tables under this user SELECT object_name| | ', ' as User_object from user_objects where object_ty

the using Filesort, originally is supposed to be the first order by C3,C2 sort will appear filesort, but the front already has c2= ' A2 ' condition, C2 already is the constant value, so C2 actually does not have the sortfive, multi-table connection in the index from the table can increase the speedCase 1: Case of two-table connection, when multiple table connections are indexed in the primary table or from the tableIf the index is not used　　The left link to the index is built in the associated

update is too frequent for fields that do not fit to create an index.12. Fields that do not appear in the Where condition should not be indexed.--------------------------------------------------------------------------------Index creationCREATE [unique| CLUSTERED] INDEX index_name on table_name (PROPERTY_NAME);The unique and clustered are optional, respectively, to create a uniquely indexed and clustered index, specifically interpreted as:Unique: Indicates that each index value for this index o

= 2Slow_query_logSlow_query_log_file =/usr/local/mysql-5.6/data/slow_query.logSkip-name-resolveExplicit_defaults_for_timestamp = True #新版本关于时间戳的新特性配置Innodb_buffer_pool_size = 512MInnodb_data_file_path = Ibdata1:256m:autoextendInnodb_file_io_threads = 4Innodb_thread_concurrency = 8Innodb_flush_log_at_trx_commit = 2Innodb_log_buffer_size = 16MInnodb_log_file_size = 128MInnodb_log_files_in_group = 3innodb_max_dirty_pages_pct = 90Innodb_lock_wait_timeout = 120innodb_file_per_table = 1Innodb_flush_m

a validation information table in the main library (3) Verifying master-slave data consistency with pt-table-checksum in the main library In the following statement from the library, view the Last_error and find the table with inconsistent data: Then return to the operating system to execute the following command: The command can see if the table has data inconsistencies, and if so, use Pt-table-sync repair. (4) in the main library with Pt-table-sync print out the repair of inconsist

Programme I1, first package the database files on the source server (including the MDF and LDF files) and copy them to the destination server.2, unzip, and then attach the database on the target serverSummary: Suitable for large databases (50GB or more), need to quickly migrate data, and mobile hard disk space is large enough. Programme IIRestore after backup1, BackupDatabase object Right-click \ task \ BackupNote that if the database file is large, it is best to select ' Compress backup '2, res

" Note: May be in win7 , win8 cannot be installed in the usual manner Please use SC mode picture with SC mode watch for c:\windows\system32\cmd.exe under Run as Administrator " . At this point the MongoDB installation is complete. You can enter the command line services.msc to run the view . There's time to be quiet listen to the song write code, design a project, from beginning to end a project to develop a summary is also good.

(4000)DECLARE @SqlCount NVARCHAR (4000)DECLARE @Top intif (@sys_Begin Set @sys_Begin =0ElseSet @[email protected]_begin-1IF ISNULL (@sys_Where, ") ="SET @new_where1 = ' 'ELSESET @new_where1 = ' WHERE ' + @sys_WhereIF ISNULL (@sys_Order, ') BEGINSET @new_order1 = ' ORDER by ' + Replace (@sys_Order, ' desc ', ')SET @new_order1 = Replace (@new_order1, ' ASC ', ' desc ')SET @new_order2 = ' ORDER by ' + @sys_OrderENDELSEBEGINSET @new_order1 = ' ORDER by ID DESC 'SET @new_order2 = ' ORDER by ID ASC '

unchanged after it is defined. Therefore, even though the data in the task table is changing all the time, the results of tasks are fixed. Using Queryselectfield The solution is still there, that is, the use of Queryselectfield,queryselectfield is not in the Wtforms.fields file, so we do not know that it exists. and Wtforms's official website also recommended US Using Selectfield support to fetch records from the database, which led us to think that we could use them, I ignored Queryselectfiel

1.RowNumber() Over (oder by ...) Use when you need to sort a table for a discontinuous ID2.row_number () Over (PARTITION by ...... ...) When you need to partition a table first, and then sort operations within a partition, use the3.RANK() over [order by ...] when you need to sort a field with the same name (regardless of side-by-side)4.Dense_rank() over (order by ...) (ditto, but consider a side position)5.NTILE(the order by ...) divides the data table into 30 groups, ensuring that each group of

directory Switch command, you need to jump to any directoryNote: Directories under the Linux root directory are: usr, home, etc, bin, devFor example, I want to switch to home directory CD home or CD ~Other commands, CD. (to the top level of the directory), CD/(to root), CD. /(to current directory), CD-(returns the previous level in the history)2, PWD, this command does not introduce more, is used to display the current directory path command3. Scene LearningFor example: I want to see the first

When you switch to ADO. NET, you will need to know how to deal with the scenarios that previously known to be handled with ADO. NET, but now must be solved with ADO. NET. Just as the N-layer solution developed using Visual Basic, C ++, and ASP often relies on ADO to meet data access needs, Windows? Forms, Web forms, and Web services must also depend on ADO. NET. I have discussed how to use ADO. NET to handle some data access

backup files of small databases (less than 10 GB), we can import them directly. Recovery of large-capacity databases (GB or TB level) is not difficult after the backup files are obtained to the local machine. For specific restoration methods, see section 3. III. MySQL migration practices In the interview, why should we perform migration and what needs to be done for migration? next, how should we perform the operation in the production environment. Different application

surprisingly similar compared to these two combinations, but there are some differences:Package Capacity:Docker image, can be easily implemented on the CentOS run Ubuntu, and very light, this is rpm,deb do not have;This is very valuable in some testing, learning, or small-scale PAAs scenarios;But for any larger-scale application, I think it is unlikely that such a deployment will occur;Package granularity and Dependency management:Docker since the ke

surprisingly similar compared to these two combinations, but there are some differences:Package Capacity:Docker image, can be easily implemented on the CentOS run Ubuntu, and very light, this is rpm,deb do not have;This is very valuable in some testing, learning, or small-scale PAAs scenarios;But for any larger-scale application, I think it is unlikely that such a deployment will occur;Package granularity and Dependency management:Docker since the ke

In this article, we will describe the most common usage scenarios for Redis, and the different features that affect our choices.1. Session CacheOne of the most common scenarios for using Redis is the session cache. The advantage of using a Redis cache session over other storage (such as memcached) is that Redis provides persistence. When maintaining a cache that is not strictly consistent, if the user's sho