Git Product home page Git Product logo

hive-simpledate's Introduction

hive-simpledate

SimpeDate UDF für Apache Hive

Maven

1. Maven vorbereiten
mvn clean
  1. Unittest ausführen
    mvn test

  2. Jar Builden
    mvn install --> hive-simpledate-0.12.0.jar

Hive

1. Hive Tabelle erstellen die ein Feld mit einem Datum als String zurückliefert.
Z.b. datum |debug_level |debug_message
Tue Jul 29 10:00:47 2014|info |Init: Seeding PRNG with 136 bytes of entropy
Tue Jul 29 10:00:47 2014|info |Init: Generating temporary RSA private keys (512/1024 bits)
Tue Jul 29 10:00:47 2014|info |Init: Generating temporary DH parameters (512/1024 bits)
  1. Hive starten und das Jar mit der Funktion laden
    add jar {path}/hive-simpledate-0.12.0-SNAPSHOT.jar;

  2. Die Funktion im Hive bekannt machen
    create temporary function simpledate as 'ch.circle6.hive.udf.SimpleDateUDF';

  3. Die Funktion simpledate verwenden
    -select simpledate(datum, 'EEE MMM dd HH:mm:ss yyyy'), debug_level, debug_message from migzs374_errorlog limit 10;
    -select simpledate(datum, 'EEE MMM dd HH:mm:ss yyyy', 'HH:mm:ss yyyy-MM-dd'), debug_level, debug_message from migzs374_errorlog limit 10;

hive-simpledate's People

Contributors

rwalliser avatar

Watchers

James Cloos avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.