Using Input Forms with SQL Queries – Apache Zeppelin

Apache Zeppelin is a fantastic open source web-based software that allows users to build and share great looking data visualizations using various languages, including SQL. Apache Zeppelin allows dynamic creation of text input forms in your notebooks. Input forms can be created and referenced using a simple template language. For example, using ${variable_name} in a

read more

Connecting Apache Zeppelin to MySQL

zeppelin-mysql-graph

Apache Zeppelin is a fantastic open source web-based notebook. Zeppelin allows users to build and share great looking data visualizations using languages such as Scala, Python, SQL, etc. A common back end for Zeppelin in MySQL. Here are the steps needed to connect Zeppelin a remote MySQL database: Download the MySQL Connector The first thing

read more

SELECT N Percent of Records in MySQL

The ability to select a certain percentage of records from a query or database table can be important when working with lots of data. Luckily this is easy to do in MySQL with the RAND() function and a WHERE clause. RAND() returns a random floating point number between 0 and 1, making it easy to

read more

How to Select a Random Sample of Records in MySQL

The ability to select a random sample of records from query or database table can be important when working with lots of data. Luckily this is easy to do in MySQL with the RAND() function and a WHERE clause. RAND() returns a random floating point value between 0 and 1, making it very easy to

read more

Execute MySQL Scripts on the Command Line

When working with MySQL it is often necessary to execute SQL statements or scripts programmatically from the command line. SQL statements can be included in a SQL script (text) file and executed by the MySQL Client. This can be done in a few different ways. Execute MySQL Script File from Standard Input Statements in a

read more