Aktualisierungen von August, 2016 Kommentarverlauf ein-/ausschalten | Tastaturkürzel

  • Andreas 09:37 am 28. August 2016 permalink
    Tags: Bluetooth, keyboard, ,   

    Using Magic Keyboard with Mac and Windows Computer 

    It is no problem to use an Apple Bluetooth Magic Keyboard with a Mac and an Windows computer. The following steps should be taken into account:

    1. If the Magic Keyboard was first paired with the Mac, you have to unpair it before you pair it with Windows computer.
    2. Afterwards pair the keyboard again with your Mac.
    3. Obviously 🙂 Disable Bluetooth on the computer you’re not using. if you’re using them side by side.

     
  • Andreas 11:30 am 7. August 2016 permalink
    Tags: Apache Spark, DB2, Spark SQL   

    Apache Spark 2.0: select * from 

    How to query a „regular“ databases (DB2 in this example) via JDBC in Apache Spark 2.0.

    final Dataset result = this.sparkSession.read().format("jdbc").options(this.options).load();

    Where „this.options“ is filled like

    this.options.put("driver", "com.ibm.db2.jcc.DB2Driver");
    this.options.put("url", "jdbc:db2://host:port/db2_database");
    this.options.put("user",USER_STRING);
    this.options.put("password",PWD_STRING);
    this.options.put("dbtable", sql_statement");

    Important to notice is to wrap sql_statement like this:
    (select * from table) as tmp_table

    because Spark converts this to

    select * from (select * from table) as tmp_table

    Using the select without brackets does not work.

     
c
Neuen Beitrag erstellen
j
nächster Beitrag/nächster Kommentar
k
vorheriger Beitrag/vorheriger Kommentar
r
Antwort
e
Bearbeiten
o
zeige/verstecke Kommentare
t
Zum Anfang gehen
l
zum Login
h
Zeige/Verberge Hilfe
Shift + Esc
Abbrechen