Cassandra Reports Not Running - 8.2.0 - Jaspersoft Community

Jump to content

We've recently updated our Privacy Statement, available here ×

This documentation is an older version of JasperReports Server Administration Guide. View the latest documentation.

Overview of JasperReports Server Administration
Overview of Organizations
- Single Default Organization
- Multiple Organizations
- Levels of Administrators
Overview of the Repository
- Folder Structure
- Resources
- Browsing and Searching
Overview of Users and Roles
- Administering Users and Roles
- Delegated Administration
Overview of Security
Administrator Login
- JasperReports Server Heartbeat
- Administrator Email
Administrator Pages
User and Role Management
- Managing Organizations
- Managing Users
- Managing Roles
- Managing Attributes
Repository Administration
- Resource Types
- JasperReport Structure
- Managing Folders and Resources
- Multiple Organizations in the Repository
- Repository Permissions
Data Sources
- Attributes in Data Source Definitions
- JDBC Data Sources
- Managing JDBC Drivers
- JNDI Data Sources
- AWS Data Sources
- Azure SQL Data Sources
  - Uploading an Azure Certificate File to the Repository
  - Creating an Azure SQL Server Data Source
- Snoflake Data Sources
- Hadoop-Hive Data Sources
- MongoDB Data Sources
- Virtual Data Sources
- TIBCO Data Virtualization
- XLS and XLSX Data Sources
- File Data Sources
- Bean Data Sources
Other Resources in the Repository
- Queries
- Datatypes
- Lists of Values
- Input Controls
- Query-based Input Controls
- Cascading Input Controls
  - Parameters in Input Control Queries
  - Creating a Cascading Input Control
- File Resources
Themes
- Introduction to Themes
- How Themes Work
- Administering Themes
- Creating Themes
- Working With CSS Files
Admin Console
- Schedules
- Alerts
- Diagnostics
Import and Export
- Import and Export Catalogs
- Dependencies During Import and Export
- The Import-Export Encryption Keys
- Import and Export Through the Web UI
- Import and Export Through the Command Line
- Alternate Import-Export Scripts
  - Running Import from Buildomatic
  - Running Export from Buildomatic
System Configuration
- Configuration Settings in the User Interface
- Configuration for Using Proxies
- Configuration for Session Persistence
- Enabling Compression in Tomcat
- Configuring Ad Hoc
- Enabling Data Snapshots
- Enabling Data Staging
- Configuring Cloud Services
- Configuring Domains
- Configuring JasperReports Library
- Disabling Open In Editor Option
- Configuring Input Control Behavior
- Configuring the Scheduler
- Configuring Report Thumbnails
- Configuring the Heartbeat
- Configuring the Online Help
OpenTelemetry
- Usecases
- Configuring OpenTelemetry and Jaegar Agent
Server Diagnostics
- Configuring System Logs
- Using Log Collectors
- Auditing and Monitoring Events
- Configuring Auditing and Monitoring
- Using the Audit Data
  - Audit Domain Items
  - Audit Reports and Ad Hoc Views
- Using the Monitoring Data
  - Monitoring Domain Items
  - Monitoring Reports and Ad Hoc Views
- Importing and Exporting Event Data
- Real-Time Diagnostics
- Exposing Diagnostics Through Jaspersoft’s JMX Agent
- Using the Diagnostic Data in Reports
- Excluding Diagnostic Attributes
- Disabling Real-Time Diagnostics
- Server Monitoring
Troubleshooting
- Number of Users Exceeded
- Running Out of Database Connections
- Data Chooser is Slow
- Fields Not Listed in Ad Hoc Editor
- Field Names Disappear in Ad Hoc Editor
- Ad Hoc Filter With All Values Causing Error
- Ad Hoc Dimensions Too Large
- Custom URLs Not Loading in Dashboards
- Print View Not Displaying in Dashboards
- Scheduler Sending Multiple Emails
- Scheduler Not Sending STARTTLS Emails
- Scheduler Running Deleted Jobs
- Scheduler Timezones in Excel Output
- Charts Not Appearing in Excel Export
- Working With Data Sources
  - Logging JDBC Operations
  - JDBC Drivers
  - Database Permissions
  - Unique JDBC Data Source Fields
  - JDBC Database URLs
  - SQL Functions with TIBCO JDBC Drivers
  - Enabling the TIBCO JDBC Drivers for Impala and Cassandra Data Sources
  - Enabling the JDBC Driver for ElasticSearch Data Sources
  - JNDI Services on Apache Tomcat
  - JNDI Services on JBoss
  - JNDI Services on WebLogic
  - Creating a Data Source on SQL Server Using Windows Authentication
  - Upgrading Bean Data Sources
- Special Characters in Database Schemas
- Hadoop-Hive Reports Not Running
- Cassandra Reports Not Running
- Maximum Parameter Size in Wildfly
- Extra Comma Appearing in Time Stamp
- Extra Comma Appearing in Time Stamp
Localization
- Configuring JasperReports Server for Multibyte Fonts
- UTF-8 Configuration
  - Java Options
  - Tomcat
  - PostgreSQL
  - MySQL
  - Oracle
- Changing Character Encoding
- Creating a Locale
- Configuring JasperReports Server to Offer a Locale
Glossary
About This Guide

Cassandra Reports Not Running

The Cassandra architecture introduces some restrictions that other databases do no have. Certain filters such as is-one-of (IN), <, and > cannot be used with all fields. For example, you may see the following error:

Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: Cannot use IN operator
on column not part of the partition key

Cassandra clusters use partition keys to split data between nodes, but this imposes a certain segmentation of the data. This segmentation is not compatible with all filtering, because it would be very inefficient. Therefore, the definition of the partition keys in your Cassandra schema limits you to certain comparison operations on certain fields.

In general you should avoid comparison operators other than strict equality in filters on Cassandra data sources. The Cassandra reference documentation recommends not using the IN comparison "under most conditions."

For more details, see the Cassandra documentation of the SELECT WHERE clause in CQL (Cassandra Query Language).

Share

Go to documents

User Feedback

0 Comments

Recommended Comments

There are no comments to display.

×

×

Create New...