esProc

Tutorial

Function Reference

Code Reference

User Reference

External Library Guide

Data File Tool Manual

DQL Tutorial

Cluster Server Manager Manual

SPL WIN Manual
YModel

User Reference

JSON-style Parameter Guide
ReportLite

User Reference
Official Website
http://doc.esproc.com/WEB-INF/layout/application.jsp1

Overview
Getting started

Overview

DQL architecture

A quick guide
Defining Pseudo Tables

Overview

Generating pseudo table from multizone composite table

Exporting pseudo table to SPL file

Defining pseudo table’s special fields

Converting a pseudo table into an in-memory table/table sequence
DQL

Introduction

DQL definition and basic queries

Query through table association

Semantic layer

Advanced metadata design
Join query syntax

Retrieve F field

Retrieve a field of homo-dimension table/foreign key table

Aggregation

Filter

Sort

Get topN records

Group & aggregate

Join

Filter by dimension
Obtaining Metadata Information

Table

Dimension

General field

Homo-dimension tables

Sub table

Level function

Table field information

Complete metadata of JSON format
DQL Server Deployment and Integration

Deploying DQL Server

Invoking DQL Server in Java applications

Previous | Next

Defining Pseudo Tables

Read（970） Like（0） Label: define pseudotable, edit,

This chapter explains how to define pseudo tables using Metadata Editor.