Apache Hive feature

Tadpole Hive

1. Intuitive web interface (Safari, Chrome, IE, Firefox, Opera) - (O)
2. hive connection management - (O)
3. local/remote hive server connection manage - (O)
4. DDL(Data Definition Language) with hive - (O)

• CREATE, ALTER, DROP Table ( external Table ) - (O)
• Automatically create hive database from sample local data file(CSV,TSV) - (X)

5. DML(Data manipulation Language) support for Hive tables

• File upload to local hadoop cluster - (X)
• Load data to hive table - (로컬 가능, 원격불가능)
• basic DML(select, insert ..) support - (O)

6. Database View (Tree, Table, Text) - (O)
7. Query support

• show Query planner - (O)
• executing query from console - (O)
• connection to hadoop M/R web - (X)
• Download query result - (O)
• query grammar check - (?, O)

8. basic Data analysis support

• create line chart from result - (X)
• create column chart from result - (X)

9. HDFS Support

• HDFS connection manager - (X)
• File Create, Read, Upload(not update), Delete from HDFS - (X)
• Web Console to hive server - (X)

10. MapReduce job tracking - (X)

Tadpole Hive cloud.

1. hive connection management

• EC2 hive job flow connection management

2. DDL(Data Definition Language) with hive

• CREATE, ALTER, DROP Table ( external Table )
• Automatically create hive database from Amazon s3 (CSV, TSV)

3. DML(Data manipulation Language) support for Hive tables

• File upload to Amazon S3
• Load data to hive table
• Database View (Tree, Table, Text)

4. Query support

• show Query panner from EMR hive job
• executing query from console
• connection to AWS EMR hive job flow's ec2
• Download query result
• query grammar check

5. HDFS Support

• HDFS connection manager ( EC2 )
• Bucket management
• File Create, Read, Upload(not update), Delete from S3

6. Web Console to hive server
7. MapReduce job tracking over EMR