maddyscout/laravel-odbc-hive

laravel-odbc-hive is a simple hive service provider for Laravel. It provides hive Connection by extending the Illuminate Database component of the laravel framework.

v6.0.4 2019-10-30 03:00 UTC

Requires

• php: ^7.2
• illuminate/database: ^6.0

MIT

• Sukhil S S

• database
• pdo
• odbc
• laravel
• hive

README

laravel-odbc-hive is a simple hive service provider for Laravel. It provides hive Connection by extending the Illuminate Database component of the laravel framework.

• Installation
• Configuration

Installation

Add laravel-db2 to your composer.json file:

"require": {
    "sukhilss/laravel-odbc-hive": "^6.0"
}

Use composer to install this package.

$ composer update

Configuration

Configure hive using package config file

Run on the command line from the root of your project:

$ php artisan vendor:publish

Set your laravel-odbc-hive credentials in app/config/hive.php the same way as above

Supported DDL commands

Schema::connection("hive")->create('dummy_' . time(), function (Blueprint $table) {
    // Numeric Types
    $table->integer('integer_field');
    $table->bigInteger('big_integer');
    $table->smallInteger('small_integer');
    $table->tinyInteger('tinyinteger_field');
    $table->float('float_field');
    $table->double('double_field');
    $table->decimal('decimal_field');

    $table->timestamp('timestamp_field');
    $table->date('date_field');

    // String Types
    $table->string('string_field'); // String literals can be expressed with either single quotes (') or double quotes ("). 
    $table->char('char_field'); // fixed-length strings, the values should be shorter than the specified length
    $table->varChar('varchar_fied'); // varchar between 1 and 65535

    $table->boolean('boolean_field');
    $table->binary('binary_field');
});