[SOLR-8125] Umbrella ticket for Streaming and SQL issues

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Parallel SQL, streaming expressions
• Assignee: Unassigned
• Reporter: Joel Bernstein
• Created: 05/Oct/15 13:43
• Updated: 08/Oct/19 14:51

Description

This is an umbrella ticket for tracking issues around the Streaming API, Streaming Expressions and Parallel SQL.

Issues can be linked to this ticket and discussions about the road map can also happen on this ticket.

Issue Links

• is related to: SOLR-8521 Add documentation for how to use Solr JDBC driver with SQL client like DB Visualizer
• is related to: SOLR-8919 Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface
• is related to: SOLR-8190 Implement Closeable on TupleStream
• is related to: SOLR-8799 Improve error message when tuple can't be read by SolrJ JDBC
• is related to: SOLR-8861 Fix missing CloudSolrClient.connect() before getZkStateReader in solrj.io classes
• is related to: SOLR-8613 SolrJ JDBC - SQL queries with limit do not fail when a bad column is provided
• is related to: SOLR-9372 Different data types returned depending on the aggregation mode used to execute a SQL statement
• is related to: SOLR-8969 SQLHandler causes NPE in non-cloud mode
• is related to: SOLR-8176 Model distributed graph traversals with Streaming Expressions
• is related to: SOLR-7525 Add ComplementStream to the Streaming API and Streaming Expressions
• is related to: SOLR-7535 Add UpdateStream to Streaming API and Streaming Expression
• is related to: SOLR-8479 Add JDBCStream for integration with external data sources
• is related to: SOLR-8659 Improve Solr JDBC Driver to support more SQL Clients
• is related to: SOLR-8502 Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
• is related to: SOLR-8527 Improve JdbcTest to cleanup properly on failures
• is related to: SOLR-8529 Improve JdbcTest to not use plain assert statements
• is related to: SOLR-8888 Add shortestPath Streaming Expression
• is related to: SOLR-9302 Better error message when running SQL queries in standalone mode
• is related to: SOLR-8185 Add operations support to streaming metrics
• is related to: SOLR-8385 Narrow StreamFactory.withFunctionName clazz parameter to prevent misconfiguration.
• is related to: SOLR-8184 Negative tests for JDBC Connection String
• relates to: SOLR-8285 Ensure the /export handler works with NULL field values.
• relates to: SOLR-8461 CloudSolrStream and ParallelStream can choose replicas that are not active
• relates to: SOLR-8625 SQL: Wrong error msg if stmt param is missing
• relates to: SOLR-8179 SQL JDBC - DriverImpl loadParams doesn't support keys with no values in the connection string
• relates to: SOLR-8337 Add ReduceOperation and wire it into the ReducerStream
• relates to: SOLR-8409 Complex q param in Streaming Expression results in a bad query
• relates to: SOLR-8443 Change /stream handler http param from "stream" to "expr"
• relates to: SOLR-8679 Implement the JMS specification on top of the TopicStream
• relates to: SOLR-8680 Distribute JDBC driver as a separate jar
• relates to: SOLR-8706 Add SMSStream to support SMS messaging
• relates to: SOLR-8571 Wire the ConcatOperation into the SQLhandler
• relates to: SOLR-8577 Add AlertStream and ModelStream to the Streaming API
• relates to: SOLR-8588 Add TopicStream to the streaming API to support publish/subscribe messaging
• relates to: SOLR-8763 Add EvalStream to support "computing on the code" use cases
• relates to: SOLR-7904 Make FacetStream Expressible
• relates to: SOLR-8002 Add column alias support to the Parallel SQL Interface
• relates to: SOLR-8086 Add support for SELECT DISTINCT queries to the SQL interface
• relates to: SOLR-8556 Add ConcatOperation to be used with the SelectStream
• relates to: SOLR-8591 Add BatchStream to the Streaming API
• relates to: SOLR-9146 Parallel SQL engine should support >, >=, <, <=, <>, != syntax
• relates to: SOLR-7525 Add ComplementStream to the Streaming API and Streaming Expressions
• relates to: SOLR-8138 Simple UI for issuing SQL queries
• relates to: SOLR-8487 Add CommitStream to Streaming API and Streaming Expressions
• relates to: SOLR-8213 SolrJ JDBC support basic authentication
• relates to: SOLR-8608 Improve SolrJ JDBC testing
• relates to: SOLR-8664 Support exporting score from the /export handler
• relates to: SOLR-8786 Ensure Solr's JDBC Driver works with Apache Zeppelin
• relates to: SOLR-8153 Support upper case and mixed case column identifiers in the SQL interface
• relates to: SOLR-8180 Missing logging dependency in solrj-lib for SolrJ
• relates to: SOLR-8593 Integrate Apache Calcite into the SQLHandler
• relates to: SOLR-7584 Add Joins to the Streaming API and Streaming Expressions
• relates to: SOLR-7669 Add SelectStream to Streaming API
• relates to: SOLR-7938 MergeStream to support N streams
• relates to: SOLR-8188 Add hash style joins to the Streaming API and Streaming Expressions
• relates to: SOLR-8198 Change ReducerStream to use StreamEqualitor instead of StreamComparator
• relates to: SOLR-8458 Add Streaming Expressions tests for parameter substitution
• relates to: SOLR-8268 Makes StatsStream implement Expressible interface
• relates to: SOLR-8432 Split StreamExpressionTest into separate tests
• relates to: SOLR-8661 Upgrade guava version to 18.0 due to Presto dependency