Streamsets Data Collector 1.6.0.0 has been released!

The release 1.6.0.0 of the Streamsets Data Collector has been released on September 1st. This release comes with an incredible number of new features. Here are some of the most interesting:

JDBC Lookup processor: it can perform lookups in a database table through a JDBC connection and then you can use the values to enrich records.
JDBC Tee processor: it can write data to a database table through a JDBC connection, and then you can pass generated database column values to fields.
Support for reading data from paginated webpages through the HTTP origin.
Support for Apache Kafka 0.10 and ElasticSearch 2.3.5.
Enterprise security in the MongoDB origin and destination including SSL and login credentials.
Whole File Data format: to move entire files from an origin system (Amazon S3 or Directory) to a destination system (Amazon S3, HDFS, Local File System or MapR FS). Using the whole file data format, you can transfer any type of file.

And many more.
Furthermore, it is now possible to download a smaller installer package (TGZ or RPM) and then install manually only the individual packages you really need. Here is the sequence of commands for the core TGZ archive to download it and installing the required stages:

# extract the tar file
$ tar xvzf streamsets-datacollector-core-1.6.0.0.tgz

$ cd

streamsets-datacollector-core-1.6.0.0

# list all downloadable stage libraries
$ ./bin/streamsets stagelibs -list


# install stage libraries as required
$ ./bin/streamsets stagelibs -install=<stageid1>,<stageid2>

Enjoy it!

Comments

Exporting InfluxDB data to a CVS file

Sometimes you would need to export a sample of the data from an InfluxDB table to a CSV file (for example to allow a data scientist to do some offline analysis using a tool like Jupyter, Zeppelin or Spark Notebook). It is possible to perform this operation through the influx command line client. This is the general syntax: sudo /usr/bin/influx -database '<database_name>' -host '<hostname>' -username '<username>' -password '<password>' -execute 'select_statement' -format '<format>' > <file_path>/<file_name>.csv where the format could be csv , json or column . Example: sudo /usr/bin/influx -database 'telegraf' -host 'localhost' -username 'admin' -password '123456789' -execute 'select * from mem' -format 'csv' > /home/googlielmo/influxdb-export/mem-export.csv

jOOQ: code generation in Eclipse

jOOQ allows code generation from a database schema through ANT tasks, Maven and shell command tools. But if you're working with Eclipse it's easier to create a new Run Configuration to perform this operation. First of all you have to write the usual XML configuration file for the code generation starting from the database: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-2.0.4.xsd"> <jdbc> <driver>oracle.jdbc.driver.OracleDriver</driver> <url>jdbc:oracle:thin:@dbhost:1700:DBSID</url> <user>DB_FTRS</user> <password>password</password> </jdbc> <generator> <name>org.jooq.util.DefaultGenerator</name> <database> <name>org.jooq.util.oracle.OracleDatabase</name> ...

Turning Python Scripts into Working Web Apps Quickly with Streamlit

I just realized that I am using Streamlit since almost one year now, posted about in Twitter or LinkedIn several times, but never wrote a blog post about it before. Communication in Data Science and Machine Learning is the key. Being able to showcase work in progress and share results with the business makes the difference. Verbal and non-verbal communication skills are important. Having some tool that could support you in this kind of conversation with a mixed audience that couldn't have a technical background or would like to hear in terms of results and business value would be of great help. I found that Streamlit fits well this scenario. Streamlit is an Open Source (Apache License 2.0) Python framework that turns data or ML scripts into shareable web apps in minutes (no kidding). Python only: no front‑end experience required. To start with Streamlit, just install it through pip (it is available in Anaconda too): pip install streamlit and you are ready to execute the working de...

Googlielmo's blog

Search This Blog