[ 
https://issues.apache.org/jira/browse/HADOOP-3601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12626704#action_12626704
 ] 

Prasad Chakka commented on HADOOP-3601:
---------------------------------------

yw kim,

it works fine with  mysql version 5.0.44_2_3. can you check this mysql bug 
report http://bugs.mysql.com/bug.php?id=28138 and use corresponding version.

| SD_PARAMS | CREATE TABLE `SD_PARAMS` (
  `STORAGE_DESC_ID_OID` bigint(20) NOT NULL,
  `PARAM_KEY` varchar(256) character set latin1 collate latin1_bin NOT NULL,
  `PARAM_VALUE` varchar(1024) character set latin1 collate latin1_bin default 
NULL,
  PRIMARY KEY  (`STORAGE_DESC_ID_OID`,`PARAM_KEY`),
  KEY `SD_PARAMS_N49` (`STORAGE_DESC_ID_OID`),
  CONSTRAINT `SD_PARAMS_FK1` FOREIGN KEY (`STORAGE_DESC_ID_OID`) REFERENCES 
`STORAGE_DESC` (`STORAGE_DESC_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |


> Hive as a contrib project
> -------------------------
>
>                 Key: HADOOP-3601
>                 URL: https://issues.apache.org/jira/browse/HADOOP-3601
>             Project: Hadoop Core
>          Issue Type: Wish
>    Affects Versions: 0.17.2
>         Environment: N/A
>            Reporter: Joydeep Sen Sarma
>            Assignee: Ashish Thusoo
>            Priority: Minor
>             Fix For: 0.19.0
>
>         Attachments: hive.tgz, hive.tgz, HiveTutorial.pdf
>
>   Original Estimate: 1080h
>  Remaining Estimate: 1080h
>
> Hive is a data warehouse built on top of flat files (stored primarily in 
> HDFS). It includes:
> - Data Organization into Tables with logical and hash partitioning
> - A Metastore to store metadata about Tables/Partitions etc
> - A SQL like query language over object data stored in Tables
> - DDL commands to define and load external data into tables
> Hive's query language is executed using Hadoop map-reduce as the execution 
> engine. Queries can use either single stage or multi-stage map-reduce. Hive 
> has a native format for tables - but can handle any data set (for example 
> json/thrift/xml) using an IO library framework.
> Hive uses Antlr for query parsing, Apache JEXL for expression evaluation and 
> may use Apache Derby as an embedded database for MetaStore. Antlr has a BSD 
> license and should be compatible with Apache license.
> We are currently thinking of contributing to the 0.17 branch as a contrib 
> project (since that is the version under which it will get tested internally) 
> - but looking for advice on the best release path.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to