janikvonrotz

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

Datatypes

Text types

bradfordcp

Securing Apache Spark with Apache Shiro

1. Download shiro-core-1.2.5.jar Apache Shiro Downloads
2. Download shiro-web-1.2.5.jar Apache Shiro Downloads
3. Note the location of the JAR files and shiro.ini. I placed it in the root of my Spark download
4. Update the spark-env.sh file with the Shiro JARs and add an entry for the path where the shiro.ini resides
5. Start the Spark master sbin/start-master.sh
6. Navigate to the Spark master dashboard
7. Authenticate with credentials in shiro.ini

Note this was developed / tested with Apache Spark 1.4.1, but should work with newer versions as well.

dtheodor

Following instructions at

• https://mariadb.com/kb/en/mariadb/preparing-for-columnstore-installation/
• https://mariadb.com/kb/en/mariadb/installing-and-configuring-mariadb-columnstore/

Install

sudo yum -y install boost expect perl perl-DBI openssl zlib snappy libaio
wget https://downloads.mariadb.com/ColumnStore/1.0.8/centos/x86_64/7/mariadb-columnstore-1.0.8-1-centos7.x86_64.rpm.tar.gz

devin-petersohn