Adding data formats

When adding new data formats to SQL Stream Builder, you need to specify the property list and must upload the data format JAR file to the Console.

  1. Navigate to the Streaming SQL Console.
    1. Go to your cluster in Cloudera Manager.
    2. Select SQL Stream Builder from the list of services.
    3. Click SQLStreamBuilder Console.
      The Streaming SQL Console opens in a new window.
  2. Open a project from the Projects page of Streaming SQL Console.
    1. Select an already existing project from the list by clicking the Open button or Switch button.
    2. Create a new project by clicking the New Project button.
    3. Import a project by clicking the Import button.
    You are redirected to the Explorer view of the project.
  3. Open External Resources from the Explorer view.
  4. Click next to Data Formats.
  5. Click New Connector.
  6. Provide a name for the data format as Type.
  7. Upload the data format JAR file.
  8. Click Properties to add properties to the data format.
    1. Add a name to the property.
    2. Add a default value to the property.
    3. Add a description to the property.
    4. Click Required to make a property mandatory.
    5. Click Add to specify more properties.
    You can specify as many properties as needed for the data format.
  9. Click Create.
    The newly added data format is listed under the Data Formats.