# Numeric Data Type Aliases

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: Numeric Data Type Aliases
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-data-types/numeric-type/numeric-data-type-aliases
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-data-types/numeric-type/numeric-data-type-aliases.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-data-types/numeric-type/numeric-data-type-aliases.adoc
description: Aliases for the primary numeric data types in Redpanda SQL, mapped to their primary types during processing.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-data-types/numeric-type/numeric-data-type-aliases.md -->

Redpanda SQL accepts aliases that you can use interchangeably with the primary data types. During processing, Redpanda SQL maps these aliases to their corresponding primary data types.

The following sections describe the numeric data type aliases:

## [](#integer-alias)`integer` alias

The `integer` alias is an alternative name for the `int` data type. For example, the following two queries are functionally the same:

```sql
CREATE TABLE ExampleTable (
    id INTEGER
);

-- Functionally the same as the previous table
CREATE TABLE AnotherTable (
    id INT,
);
```

> 📝 **NOTE**
>
> Even though you specify the `integer` alias in DDL, Redpanda SQL stores and treats the data as `int`.

## [](#long-alias)`long` alias

The `long` alias is often used to represent larger integer values. For example:

```sql
CREATE TABLE LargeValues (
    value LONG
);

-- Functionally the same as the previous table
CREATE TABLE LargeValuesEquivalent (
    value BIGINT
);
```

> 📝 **NOTE**
>
> Even though you specify the `long` alias in DDL, Redpanda SQL stores and treats the data as `bigint`.

## [](#float-alias)`float` alias

The `float` alias corresponds to the `real` data type. For example:

```sql
CREATE TABLE FloatExample (
    price FLOAT
);

-- Functionally the same as the previous table
CREATE TABLE FloatEquivalent (
    price REAL
);
```

> 📝 **NOTE**
>
> Even though you specify the `float` alias in DDL, Redpanda SQL stores and treats the data as `real`.

## [](#double-alias)`double` alias

The `double` alias defines `double precision` floating-point numbers. For example:

```sql
CREATE TABLE DoubleExample (
    measurement DOUBLE
);

-- Functionally the same as the previous table
CREATE TABLE DoubleEquivalent (
    measurement DOUBLE PRECISION
);
```

> 📝 **NOTE**
>
> Even though you specify the `double` alias in DDL, Redpanda SQL stores and treats the data as `double precision`.