I've configured Hortonworks HDP with ambari services, later I add HAWQ and PXF. Through some research i've seen that is possible to query data stored in Hive through HCatalog and since i already loaded the dataset to hive it would easy the work, but i am doing some benchmark, can someone tell me if the use of the Hcatalog affects HAWQ in terms of performance?
Acessing Hive Data on HAWQ/PXF with HCatalog
109 Views Asked by Mário Rodrigues At
2
There are 2 best solutions below
Related Questions in HIVE
- How do I set the Hive user to something different than the Spark user from within a Spark program?
- schedule and automate sqoop import/export tasks
- PIG merge two lines in the log
- Elephant bird with hive to query protobuf file
- How can we decide the total no. of buckets for a hive table
- How to create a table in Hive with a column of data type array<map<string, string>>
- How to find number of unique connection using hive/pig
- sqoop-export is failing when I have \N as data
- How can we test expressions in hive
- Run Hive Query in R with Config
- Rhive: The messages shows: Not Connected to Hiveserver2 (But can connect HDFS)
- HIVE Query Deleting source data blob
- Hive JOIN of query with subquery takes forever
- What is Metadata DB Derby?
- How could I set the number or size of output files in an "insert" script?
Related Questions in HORTONWORKS-DATA-PLATFORM
- How to diagnose Kafka topics failing globally to be found
- Setting mapreduce.job.jar with a jar in path containing space
- Spark read file from S3 using sc.textFile ("s3n://...)
- Connect to Oracle via sqoop on Hortonworks Sandbox
- SparkAction for yarn-cluster
- Pig xmlloader error when loading tag with colon
- HDP cluster how define disk partition?
- Ambari version tab not displaying anything
- Hive - How to print the classpath of a Hive service
- Only Sensitive values IN GetFile Processor?
- Shell action with awscli commands for s3 buckets in Oozie
- Distcp - Container is running beyond physical memory limits
- Ambari server LDAP setupp error
- How to handle comma separated decimal values in Hive?
- RandomForest via Spark causing Heap Space error
Related Questions in AMBARI
- Ambari Monitoring raw data
- boot2docker ssh apache-kylin windows7 source ambari-functions ambari-functions ERROR : line 11: syntax error: bad function name
- Oozie on YARN - oozie is not allowed to impersonate hadoop
- What are the steps to upgrade Spring XD using the Ambari Plugin?
- HDP cluster how define disk partition?
- Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password) during ambari hadoop installation
- How to intergrate hadoop using ambari without HDP?
- Ambari version tab not displaying anything
- Ambari server LDAP setupp error
- Ambari Custom Hadoop installation
- How to bypass user login in ambari web
- Installation BigInsights 4.2
- In ambari install options should I add Ambari-Server IP/hostname?
- Pig script runs fine on Sandbox but fails on a real cluster
- does ambari use nagios
Related Questions in HCATALOG
- saveAsTable in Spark 1.4 is not working as expected
- Where does Hadoop Hcatalog store databases and tables?
- Apache PIG - ERROR org.apache.pig.impl.PigContext - Encountered " <OTHER> ",= "" at line 1, column 1
- How to import table data stored in Hive in my MapReduce job?
- Simple Producer Consumer used to send partition notification using HCATALOG
- Pig and HCatalog
- Writing to multiple HCatalog schemas in single reducer?
- HCatalog configured with Hive
- Issues saving to Hive table from Pig
- Merge two bag and get all the field from first bag in pig
- Hadoop + Hive - hcatalog won't startup
- Connecting HDP from Teradata Studio Express 15.10
- could not resolve org.apache.hcatalog.pig.hcatloader using imports
- Using Hive with Pig through HCatalog issue with TimeStamp datatype
- Trigger to HCATALOG
Related Questions in HAWQ
- HAWQ stop cluster failed
- Why doesn't HAWQ support index for non-heap tables currently?
- PIVOTAL HAWQ- PXF connection is not working
- How to load data from oracle and sql server to HAWQ using Spring XD
- Greenplum - Out of memory
- Query failing with "ERROR: Canceling query because of high VMEM usage"
- what are the Hadoop requirements for hawq 2.4
- How to push data from HAWQ into GREENPLUM?
- Error when installing "hawq init cluster" on Docker, ,"internal_load_library","dfmgr.c",208
- Greenplum - How To Handle Deadlock
- Hadoop - Hawq - Add new segment
- HAWQ PostgreSQL - Increment row based on previous row
- Talend greenplumRow error handling
- Select query not working on external table
- Greenplum Delete statement not working
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
When HAWQ accesses PXF tables using HCatalog integration, it determines format of underlying table(and even partition) and uses profile, optimized for that particular format, so there should be no performance degradation.