Tag: INSERT

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Python 2.1.7 GA is a fifth GA version of 2.1 release series of the pure Python database driver for MySQL. It can be used for production environments. MySQL Connector/Python version 2.1.7 GA is compatible with MySQL Server versions 5.5 and greater. Python 2.6 and greater as well as Python 3.4 and greater are supported. Python 2.4, 2.5, and 3.1, 3.2, 3.3 are not supported. MySQL Connector/Python 2.1.7 is available for download from: http://dev.mysql.com/downloads/connector/python/#downloads MySQL Connector/Python 2.1.7 (Commercial) will be available for download on the My Oracle Support (MOS) website. This release ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Venkatesan M. 1) Compare Hadoop & Spark                       Criteria                                           Hadoop                                                   Spark Dedicated storage                           HDFS                 ... Read More

Feed: CDH – Cloudera Engineering Blog. Author: Justin Kestelyn. CDH 5.7 includes a lot of changes (more than 1,500) to Hue, the Web UI that makes Apache Hadoop easier to use. In this new release, the emphasis on performance and security carries over from 5.5. The overall improvement in the SQL user experience is also considerable. In this post, we’ll cover some highlights. New Hive Metastore Interface This app is now on a single page, offering more speed and easier access to statistics and data previews. Read about more of the improvements below; or, watch a demo of all of them in action ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; TL;DR: unless you know what you are doing, you should always have a primary key on your tables when replicating in RBR (and maybe even all the time). TL;DR2: MariaDB 10.1 has an interesting way to protect against missing a primary key (innodb_force_primary_key) but it could be improved.A few weeks ago, I was called off hours because replication delay on all the slaves from a replication chain was high and growing.  It was not the first time this happened on that chain, so I thought right away that this was probably an UPDATE or DELETE of many ... Read More

Feed: Hortonworks Blog – Hortonworks. Author: Carter Shanklin. This is part 1 of a 2 part series for how to update Hive Tables the easy way Historically, keeping data up-to-date in Apache Hive required custom application development that is complex, non-performant and difficult to maintain. HDP 2.6 radically simplifies data maintenance with the introduction of SQL MERGE in Hive, complementing existing INSERT, UPDATE and DELETE capabilities. This blog shows how to solve common data management problems, including: Hive upserts, to synchronize Hive data with a source RDBMS. Update the partition where data lives in Hive. Selectively mask or purge data ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; In one of my previous posts, I shared InnoDB table compression statistics for a read-only dataset using the default value of innodb_compression_level (6).  In it, I claimed, without giving much detail, that using the maximum value for the compression level (9) would not make a big difference.  In this post, I will share more details about this claim.TL;DR: tuning innodb_compression_level is not very useful for my dataset. In the previous post, I explained how I am compressing InnoDB tables for a specific read-only dataset (more details can be found in the previous post).  I also present a ... Read More

Feed: Planet MySQL; Author: MariaDB; MariaDB ColumnStore 1.0 supports User Defined Functions (UDF) for query extensibility. This allows you to create custom filters and transformations to suit any need. This blog outlines adding support for distributed JSON query filtering.  An important MariaDB ColumnStore concept to grasp is that there are distributed and non-distributed functions. Distributed functions are executed at the PM nodes supporting query execution scale out. Non distributed functions are MariaDB Server functions that are executed within the UM node. As a result, MariaDB ColumnStore requires two distinct implementations of any function. The next release, MariaDB ColumnStore 1.1, will ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Jervin Real  | August 11, 2017 |  Posted In: MySQL PREVIOUS POST In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7! First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here. I received a number of interesting questions in the webinar that I’ve followed up with below. Would there be a big difference on passing from 5.1 to 5.6 before going to 5.7 or, at this point, would it be roughly the same? The biggest ... Read More

Feed: Planet MySQL; Author: Dave Stokes; JSON in Flat File to MySQL Database So how do you load that JSON data file into MySQL. Recently I had this question presented to me and I thought I would share a handy script I use to do such work. For this example I will use the US Zip (postal) codes from JSONAR. Download and unzip the file. The data file is named zips.json and it can not be bread directly into MySQL using the SOURCE command. It needs to have the information wrapped in a more palatable fashion. head zips.json { "city" ... Read More

Feed: Hortonworks Blog – Hortonworks. Author: Nadeem Asghar. Attunity is a long-time Hortonworks partner who provides data optimization and data integration software to help Hortonworks customers address exploding data growth, efficiently manage the performance of BI and data warehouse systems, and realize the tremendous economies of Apache Hadoop®. Attunity solutions are certified on HDF, HDP and are YARN Ready. Together, Hortonworks and Attunity are committed to advancing Hadoop through community-led innovation. This new solution is one more example of that. Attunity Compose for Hive By Jordan Martz, Director of Technology Solutions, Attunity Attunity Compose for Hive automates the data pipeline ... Read More