Apache Hive feature

Tadpole DB Hub에 포함될 Apache Hive의 기능정리

Tadpole Hive

2. =* Intuitive web interface (Safari, Chrome, IE, Firefox, Opera)

• hive connection management
• local/remote hive server connection manage
• DDL(Data Definition Language) with hive CREATE, ALTER, DROP Table ( external Table )
• Automatically create hive database from sample local data file(CSV,TSV) DML(Data manipulation Language) support for Hive tables
• File upload to local hadoop cluster
• Load data to hive table
• basic DML(select, insert ..) support Database View (Tree, Table, Text) Query support
• show Query planner
• executing query from console
• connection to hadoop M/R web
• Download query result
• query grammar check basic Data analysis support
• create line chart from result
• create column chart from result HDFS Support
• HDFS connection manager
• File Create, Read, Upload(not update), Delete from HDFS
• Web Console to hive server
• MapReduce job tracking

Tadpole hive cloud.

hive connection management

• EC2 hive job flow connection management DDL(Data Definition Language) with hive
• CREATE, ALTER, DROP Table ( external Table )
• Automatically create hive database from Amazon s3 (CSV, TSV) DML(Data manipulation Language) support for Hive tables
• File upload to Amazon S3
• Load data to hive table
• Database View (Tree, Table, Text) Query support
• show Query planner from EMR hive job
• executing query from console
• connection to AWS EMR hive job flow's ec2
• Download query result
• query grammar check HDFS Support
• HDFS connection manager ( EC2 )
• Bucket management
• File Create, Read, Upload(not update), Delete from S3 Web Console to hive server MapReduce job tracking over EMR