Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
>
>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB