[FEA] Support decimal type

[revans2]

Is your feature request related to a problem? Please describe.
Decimal Support (in order of priority):

• FIXED_LEN_BYTE_ARRAY read parquet [FEA] Support Parquet Read of Decimal FIXED_LENGTH_BYTE_ARRAY #1324
• Basic Read Parquet Support reading decimal columns from parquet files #1294
• Join [FEA] Add in join support for decimal #1325
• Simple Hash Aggregates [FEA] Support simple DECIMAL aggregates #1316
• Broadcast [FEA] Add in Broadcast support for decimal values #1326
• Sort and Shuffle [FEA] Support sorting and shuffle of decimal #1328
• Cast [FEA] Support Decimal Casts #1330
• Add, Subtract, multiply, IntegerDivide and null safe equals [FEA] Decimal support for multiply int div, add, subtract and null safe equals #1329
• Union and ExpandExec [FEA] UnionExec and ExpandExec support for decimal #1331
• CaseWhen, Coalesce and IfElse [FEA] Support CaseWhen, Coalesce and IfElse for decimal #1332
• Window Operations [FEA] Support window operations on Decimal #1333
• Aggregate Count [FEA] Add support for count aggregate on decimal #1334
• Round/Bround issue [FEA] round and bround SQL functions #37, PR Support round and bround SQL functions  #1244

Lower priority not seen in TPC-DS

• Pmod, divide, and remainder [FEA] Add in decimal support for pmod, remainder and divide #1572
• CollectLimitExec [FEA] Support CollectLimitExec for decimal #1335
• Read ORC Support
• Read CSV and JSON Support [FEA] Support reading decimals from JSON and CSV #4824
• Write Parquet Support [FEA] Decimal Support for Parquet Write #1485
• Write ORC Support
• Decimal Casts to String and String to Decimal [FEA] Support Decimal Casts to String and String to Decimal #1625
• GenerateExec PR Add Decimal support for In, InSet, AtLeastNNonNulls, GetArrayItem, GetStructField, and GenerateExec #1410
• Python Arrow Processing [FEA] Fixed-point support for to_arrow and from_arrow rapidsai/cudf#7116
• Unary Ops (abs, ceil, floor, UnaryMinus, UnaryPositive) Add in Decimal support for abs, floor, ceil, unary - and unary + #1425
• AtLeastNNonNulls PR Add Decimal support for In, InSet, AtLeastNNonNulls, GetArrayItem, GetStructField, and GenerateExec #1410
• GetArrayItem/GetStructField PR Add Decimal support for In, InSet, AtLeastNNonNulls, GetArrayItem, GetStructField, and GenerateExec #1410
• Greatest/Least
• In/InSet PR Add Decimal support for In, InSet, AtLeastNNonNulls, GetArrayItem, GetStructField, and GenerateExec #1410

This issue builds on rapidsai/cudf#6515

[revans2]

rapidsai/cudf#3556 is the cudf issue to support this.

[sameerz]

This is an umbrella issue for decimal support. We will tag other decimal related issues to this one.

[sperlingxx]

I think #37 is related to this issue.

[razajafri]

I think #37 is related to this issue.

Yes, it's related and listed in the table above

[sameerz]

Decimal writing is still unsupported for JSON, Avro and CSV. That work will be tracked in epics for those writers.