Hi,

Does anyone know of the SQL limits for Hive? Particularly the following:
1.      The maximum number of tables in join, aka, the maximum number of tables in a select query
2.      The maximum number of columns in creating an index
3.      Maximum size of SQL string accepted by ODBC driver
4.      The maximum length of a column name

Any insight much appreciated.

Thanks.
Farah

Hi Farah,
#2 and #4 should be easy to figure by taking a look at the metastore
scripts. For example, I took a quick look at
https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.10.0.mysql.sql
and it seems like 128 is the answer to #4

#1 and #3 I am not entirely sure. I am not sure of any such
restriction for #1. For #3 your best bet is to look at the ODBC driver
code.

Mark

On Mon, Dec 17, 2012 at 11:48 AM, Omer, Farah <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Does anyone know of the SQL limits for Hive? Particularly the following:
>
>
> 1.      The maximum number of tables in join, aka, the maximum number of tables in a select query
> 2.      The maximum number of columns in creating an index
> 3.      Maximum size of SQL string accepted by ODBC driver
> 4.      The maximum length of a column name
>
> Any insight much appreciated.
>
> Thanks.
> Farah
>
>
>
>