Upsolver
Contact Support
  • Welcome to Upsolver
  • Getting Started
    • Start using Upsolver for free
    • Get started as a Upsolver user
      • Upsolver in 5 minutes
        • Upsolver Quickstart in 5 minutes
          • Additional sandbox fun
        • Amazon Athena data output
        • MySQL (AWS RDS) data output
        • Local MySQL data output
      • Upsolver free training
        • Introduction to Upsolver
          • Transform and write data to Amazon Athena
          • Pre-aggregate data for efficiency and performance
          • UPSERT streaming data to Amazon Athena
      • Prerequisites for AWS deployment
      • AWS integration
      • Deploy Upsolver on your AWS account
      • Prerequisites for Azure Deployment
      • Azure Integration
        • Prerequisites for Azure Users
        • Log into Upsolver
        • Log into Azure & Authenticate
        • Set Up and Deploy Azure Resources
        • Delegate Resource Group, and Deploy Upsolver in Azure
        • Integrate Azure with Upsolver
    • Upsolver concepts
      • Deployment models
      • Upsolver components
      • Data ingestion
    • Upsolver Amazon AWS deployment guide
      • Private VPC
      • Upsolver VPC
      • AWS role permissions
      • VPC peering
    • Tutorials and FAQ
      • Tutorials
        • How To Re-process Data
        • Create an Amazon S3 data source
        • Create an Amazon Athena data output
        • Join multiple data streams for real-time analytics
        • Use Upsolver to index less data into Splunk
        • Upsert and delete use case
        • AWS S3 to Athena use case
        • Merge data use case
        • Full vs. Partial Inbound Data Records
      • FAQ
      • Infrastructure
        • What is a dry-run cluster?
    • Glossary
      • Language guide
        • SQL syntax reference
        • Functions
          • Aggregation Functions
            • APPROX_COUNT_DISTINCT
            • APPROX_COUNT_DISTINCT_EACH
            • AVG
            • AVG_EACH
            • AVG_TIME_SERIES
            • COLLECT_SET
            • COLLECT_SET_EACH
            • COUNT
            • COUNT(*)
            • COUNT_DISTINCT
            • COUNT_EACH
            • COUNT_IF
            • DECAYED_SUM
            • DYNAMIC_SESSIONS
            • FIRST
            • FIRST_ARRAY
            • FIRST_EACH
            • FIRST_TIME_SERIES
            • LAST
            • LAST_ARRAY
            • LAST_EACH
            • LAST_K
            • LAST_K_EACH
            • LAST_TIME_SERIES
            • MAX
            • MAX_BY
            • MAX_EACH
            • MAX_TIME_SERIES
            • MIN
            • MIN_BY
            • MIN_EACH
            • MIN_TIME_SERIES
            • SESSION_COUNT
            • STD_DEV
            • STD_DEV_EACH
            • STRING_MAX_EACH
            • STRING_MIN_EACH
            • SUM
            • SUM_EACH
            • SUM_TIME_SERIES
            • WEIGHTED_AVERAGE
          • Calculated functions
            • Aerospike functions
            • Array functions
            • Conditional functions
            • Date functions
            • External API functions
            • Filter functions
            • Numeric functions
            • Spatial functions
            • String functions
            • Structural functions
              • ZIP
            • Type conversion functions
      • Data formats
      • Data types and features
      • Database output options
      • Upsolver shards
      • Permissions list
      • Index
    • Troubleshooting
      • My CloudFormation stack failed to deploy
      • My private API doesn't start or I can't connect to it
        • Elastic IPs limit reached
        • EC2 Spot Instance not running
        • DNS cache
        • Security group not open
      • My compute cluster doesn't start
      • I can't connect to my Kafka cluster
      • I can't create an S3 data source
      • Data doesn't appear in Athena table
      • I get an exception when querying my Athena table
      • Unable to define a JDBC (Postgres) connection
  • Connecting data sources
    • Amazon AWS data sources
      • Amazon S3 data source
        • Quick guide: S3 data source
        • Full guide: S3 data source
      • Amazon Kinesis Stream data source
      • Amazon S3 over SQS data source
      • Amazon AppFlow data source
        • Setup Google Analytics client ID and client secret.
    • Microsoft Azure data sources
      • Azure Blob storage data source
      • Azure Event Hubs data source
    • Kafka data source
    • Google Cloud Storage data source
    • File upload data source
    • CDC data sources (Debezium)
      • MySQL CDC data source
        • Binlog retention in MySQL
      • PostgreSQL CDC database replication
    • JDBC data source
    • HDFS data source
    • Data source UI
    • Data source properties
  • Data outputs and data transformation
    • Data outputs
      • Amazon AWS data outputs
        • Amazon S3 data output
        • Amazon Athena data output
          • Quick guide: Athena data output
          • Full guide: Athena data output
          • Output all data source fields to Amazon Athena
        • Amazon Kinesis data output
        • Amazon Redshift data output
        • Amazon Redshift Spectrum data output
          • Connect Redshift Spectrum to Glue Data Catalog
        • Amazon SageMaker data output
      • Data lake / database data outputs
        • Snowflake data output
          • Upsert data to Snowflake
        • MySQL data output
        • PostgreSQL data output
        • Microsoft SQL Server data output
        • Elasticsearch data output
        • Dremio
        • PrestoDB
      • Upsolver data output
      • HDFS data output
      • Google Storage data output
      • Microsoft Azure Storage data output
      • Qubole data output
      • Lookup table data output
        • Lookup table alias
        • API Playground
        • Serialization of EACH aggregations
      • Kafka data output
    • Data transformation
      • Transform with SQL
        • Mapping data to a desired schema
        • Transforming data with SQL
        • Aggregate streaming data
        • Query hierarchical data
      • Work with Arrays
      • View outputs
      • Create an output
        • Modify an output in SQL
          • Quick guide: SQL data transformation
        • Add calculated fields
        • Add filters
        • Add lookups
          • Add lookups from data sources
          • Add lookups from lookup tables
          • Adding lookups from reference data
        • Output properties
          • General output properties
      • Run an output
      • Edit an output
      • Duplicate an output
      • Stop an output
      • Delete an output
  • Guide for developers
    • Upsolver REST API
      • Create a data source
      • Modify a data source
      • API content formats
    • CI/CD on Upsolver
  • Administration
    • Connections
      • Amazon S3 connection
      • Amazon Kinesis connection
      • Amazon Redshift connection
      • Amazon Athena connection
      • Amazon S3 over SQS connection
      • Google Storage connection
      • Azure Blob storage connection
      • Snowflake connection
      • MySQL connection
      • Elasticsearch connection
      • HDFS connection
      • Qubole connection
      • PostgreSQL connection
      • Microsoft SQL Server connection
      • Spotinst Private VPC connection
      • Kafka connection
    • Clusters
      • Cluster types
        • Compute cluster
        • Query cluster
        • Local API cluster
      • Monitoring clusters
      • Cluster tasks
      • Cluster Elastic IPs
      • Cluster properties
      • Uploading user-provided certificates
    • Python UDF
    • Reference data
    • Workspaces
    • Monitoring
      • Credits
      • Delays In Upsolver pipelines
      • Monitoring reports
        • Monitoring system properties
        • Monitoring metrics
    • Security
      • IAM: Identity and access management
        • Manage users
        • Manage groups
        • Manage policies
      • Git integration
      • Single sign-on with SAML
        • Microsoft Azure AD with SAML sign-on
        • Okta with SAML sign-on
        • OneLogin with SAML sign-on
      • AMI security updates
  • Support
    • Upsolver support portal
  • Change log
  • Legal
Powered by GitBook
On this page
  • Legal Attribution Notice
  • Java Libraries
  • Node Modules
  • PyPI Packages
  • Creative Commons Attributions

Was this helpful?

Legal

Legal Attribution Notice

Upsolver (Processing Servers, API Servers and Web Based Frontend) make use of the following open-source software libraries and components, which are subject to their respective licenses as detailed below:

Java Libraries

Organization
Package
License

Binaries containing hadoop-lzo

GPL-3.0-or-later

Binaries containing Javax.activation

GPL-2.0-or-later-with-classpath-exception OR CDDL-1.0

Binaries containing javax.el

GPL-2.0-or-later-with-classpath-exception OR CDDL-1.1

Binaries containing javax.jsonp

GPL-2.0-or-later-with-classpth-exception OR CDDL-1.1

Binaries containing jboss-jaxrs-api_spec

GPL-2.0-or-later-with-classpath-exception OR CDDL-1.0

Binaries containing JGrapht

LGPL-2.1-or-later OR EPL-2.0

Binaries containing jnr-posix

EPL-2.0 OR GPL-2.0-or-later OR LGPL-2.1-or-later

Binaries containing osgi-resource-locator 1.0.3

GPL-2.0-with-classpath-exception OR EPL-2.0

Binaries containing QuickLZ

GPL-1.0-only OR GPL-2.0-only OR GPL-3.0-only OR Commercial

ch.qos.logback

logback-classic

ch.qos.logback

logback-core

com.clojure-goes-fast

jvm-alloc-rate-meter

com.clojure-goes-fast

jvm-hiccup-meter

com.googlecode.juniversalchardet

juniversalchardet

com.mysql

mysql-connector-j

com.openhtmltopdf

openhtmltopdf-core

com.openhtmltopdf

openhtmltopdf-jsoup-dom-converter

com.openhtmltopdf

openhtmltopdf-pdfbox

com.openhtmltopdf

openhtmltopdf-rtl-support

com.oracle.ojdbc

ojdbc8

com.oracle.ojdbc

ons

com.oracle.ojdbc

oraclepki

com.oracle.ojdbc

osdt_cert

com.oracle.ojdbc

osdt_core

com.oracle.ojdbc

simplefan

com.oracle.ojdbc

ucp

com.sun.jersey.contribs

jersey-guice

com.sun.jersey

jersey-client

com.sun.jersey

jersey-core

com.sun.jersey

jersey-json

com.sun.jersey

jersey-server

com.sun.jersey

jersey-servlet

com.sun.xml.bind

jaxb-impl

Dependency on DateTimeFormatter.java from OpenJDK

GPL-2.0-only-with-classpath-exception

jakarta.activation

jakarta.activation-api

jakarta.annotation

jakarta.annotation-api

jakarta.xml.bind

jakarta.xml.bind-api

javax.annotation

javax.annotation-api

javax.mail

mail

javax.servlet.jsp

jsp-api

javax.servlet

javax.servlet-api

javax.websocket

javax.websocket-api

javax.websocket

javax.websocket-client-api

javax.ws.rs

javax.ws.rs-api

javax.ws.rs

jsr311-api

javax.xml.bind

jaxb-api

javax.xml.stream

stax-api

Maven Dependency - com.hadoop.gplcompression/hadoop-lzo 0.4.20

LGPL-3.0-or-later

me.xdrop

fuzzywuzzy

net.java.dev.jna

jna-platform

net.java.dev.jna

jna

net.openhft

zero-allocation-hashing

org.eclipse.jetty.aggregate

jetty-all

org.eclipse.jetty.http2

http2-common

org.eclipse.jetty.http2

http2-hpack

org.eclipse.jetty.http2

http2-server

org.eclipse.jetty.orbit

javax.servlet

org.eclipse.jetty.websocket

javax-websocket-client-impl

org.eclipse.jetty.websocket

javax-websocket-server-impl

org.eclipse.jetty.websocket

websocket-api

org.eclipse.jetty.websocket

websocket-client

org.eclipse.jetty.websocket

websocket-common

org.eclipse.jetty.websocket

websocket-server

org.eclipse.jetty.websocket

websocket-servlet

org.eclipse.jetty

jetty-annotations

org.eclipse.jetty

jetty-client

org.eclipse.jetty

jetty-continuation

org.eclipse.jetty

jetty-http

org.eclipse.jetty

jetty-io

org.eclipse.jetty

jetty-jmx

org.eclipse.jetty

jetty-jndi

org.eclipse.jetty

jetty-nosql

org.eclipse.jetty

jetty-plus

org.eclipse.jetty

jetty-security

org.eclipse.jetty

jetty-server

org.eclipse.jetty

jetty-servlet

org.eclipse.jetty

jetty-servlets

org.eclipse.jetty

jetty-util-ajax

org.eclipse.jetty

jetty-util

org.eclipse.jetty

jetty-webapp

org.eclipse.jetty

jetty-xml

org.eclipse.lsp4j

org.eclipse.lsp4j.generator

org.eclipse.lsp4j

org.eclipse.lsp4j.jsonrpc

org.eclipse.lsp4j

org.eclipse.lsp4j.websocket

org.eclipse.lsp4j

org.eclipse.lsp4j

org.eclipse.xtend

org.eclipse.xtend.lib.macro

org.eclipse.xtend

org.eclipse.xtend.lib

org.eclipse.xtext

org.eclipse.xtext.xbase.lib

org.glassfish.hk2.external

aopalliance-repackaged

org.glassfish.hk2

hk2-api

org.glassfish.hk2

hk2-locator

org.glassfish.hk2

hk2-utils

org.glassfish

javax.json

org.gnu

gnu-crypto

org.javassist

javassist

org.jgrapht

jgrapht-core

org.jgrapht

jgrapht-io

org.jpmml

pmml-evaluator

org.openjdk.jmh

jmh-core

org.openjdk.jmh

jmh-generator-asm

org.openjdk.jmh

jmh-generator-bytecode

org.openjdk.jmh

jmh-generator-reflection

org.openjdk.jol

jol-core

Node Modules

In addition, references and dependencies from the following node modules, which are subject to their respective licenses:

Description
License
URL

References to OpenTopoMap [Bundled with Node Module - highcharts 11.1.0]

CC-BY-SA-3.0

Dependency on OpenStreetMap [Bundled with Node Module - highcharts 11.1.0]

ODbL-1.0, Documentation: CC-BY-SA-2.0

PyPI Packages

References and dependencies from the following PyPI packages, which are subject to their respective licenses:

Description
License
URL

Geohash

AGPL-3.0-or-later

Creative Commons Attributions

Code and references from the following Creative Commons licensed sources:

URL
License

CC BY-SA

CC BY-SA

CC BY-SA-3.0

This attribution notice page is provided to comply with the respective open-source and Creative Commons licenses and ensure proper credit to the creators and maintainers of these resources.

PreviousChange log

Last updated 4 months ago

Was this helpful?

, Licenses

GPL-3.0 license, GNU GENERAL PUBLIC LICENSE
COMMON DEVELOPMENT AND DISTRIBUTION LICENSE (CDDL) Version 1.1
COMMON DEVELOPMENT AND DISTRIBUTION LICENSE (CDDL) Version 1.1
COMMON DEVELOPMENT AND DISTRIBUTION LICENSE (CDDL) Version 1.0
COMMON DEVELOPMENT AND DISTRIBUTION LICENSE (CDDL) Version 1.0
COMMON DEVELOPMENT AND DISTRIBUTION LICENSE (CDDL) Version 1.0
Eclipse Public License version 2.0 OR GNU General Public License version 2 OR GNU Lesser General Public License version 2.1
EPL 2.0
GPL2 w/ CPE
GNU General Public License v2.0
Eclipse Public License v1.0, Lesser General Public License version 2.1
Eclipse Public License v1.0, Lesser General Public License version 2.1
Eclipse Public License 1.0
Eclipse Public License 1.0
Mozilla Public License 1.1 (MPL 1.1)
GNU General Public License, v2 with Universal FOSS Exception, v1.0
GNU Lesser General Public License (LGPL), version 2.1 or later
GNU Lesser General Public License (LGPL), version 2.1 or later
GNU Lesser General Public License (LGPL), version 2.1 or later
GNU Lesser General Public License (LGPL), version 2.1 or later
Oracle Free Use Terms and Conditions (FUTC)
Oracle Free Use Terms and Conditions (FUTC)
Oracle Free Use Terms and Conditions (FUTC)
Oracle Free Use Terms and Conditions (FUTC)
Oracle Free Use Terms and Conditions (FUTC)
Oracle Free Use Terms and Conditions (FUTC)
Oracle Free Use Terms and Conditions (FUTC)
CDDL 1.1 + GPL2 w/ CPE
CDDL 1.1 + GPL2 w/ CPE
CDDL 1.1 + GPL2 w/ CPE
CDDL 1.1 + GPL2 w/ CPE
CDDL 1.1 + GPL2 w/ CPE
CDDL 1.1 + GPL2 w/ CPE
CDDL 1.1
DateTimeFormatter.java License
EPL 2.0
EPL 2.0
EPL 2.0
CDDL + GPLv2 with classpath exception
CDDL + GPLv2 with classpath exception
CDDL + GPLv2 with classpath exception
CDDL + GPLv2 with classpath exception
CDDL + GPLv2 with classpath exception
CDDL + GPLv2 with classpath exception
EPL 2.0
CDDL License
CDDL 1.1
GNU General Public Library
GNU GENERAL PUBLIC LICENSE Version 3
GPL 3
LGPL-2.1-or-later
LGPL-2.1-or-later
Apache 2.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License - Version 1.0
Eclipse Public License, Version 2.0
Eclipse Public License, Version 2.0
Eclipse Public License, Version 2.0
Eclipse Public License, Version 2.0
Eclipse Public License, Version 2.0
Eclipse Public License, Version 2.0
Eclipse Public License, Version 2.0
EPL 2.0
EPL 2.0
EPL 2.0
EPL 2.0
Dual license consisting of the CDDL v1.1 and GPL v2
The GNU General Public License
MPL 1.1
GNU Lesser General Public License Version 2.1, February 1999
GNU Lesser General Public License Version 2.1, February 1999
GNU Affero General Public License (AGPL) version 3.0
GNU General Public License (GPL), version 2, with the Classpath exception
GNU General Public License (GPL), version 2, with the Classpath exception
GNU General Public License (GPL), version 2, with the Classpath exception
GNU General Public License (GPL), version 2, with the Classpath exception
GNU General Public License (GPL), version 2, with the Classpath exception
https://opentopomap.org/about
https://www.openstreetmap.org/
https://github.com/vinsci/geohash
https://stackoverflow.com/questions/13390964/java-ssl-fatal-error-80-unwrapping-net-record-after-adding-the-https-en
https://stackoverflow.com/questions/1793979/registering-multiple-keystores-in-jvm
https://en.wikibooks.org/wiki/Regular_Expressions/POSIX_Basic_Regular_Expressions