Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Database limits for Hive


Copy link to this message
-
Re: Database limits for Hive
Mark Grover 2012-12-18, 02:01
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
>
>
>
>