Currently our databases are hosted in other databases . We are thinking to execute the process in SPARK by using JDBC connectors. Is it possible to use SPARK.SQL statements after we connect the datasource or do we have to load the data to hive to use spark.sql query?
Can we use spark.sql on any other database tables other than Hive tables?
111 Views Asked by Rahul At
1
There are 1 best solutions below
Related Questions in DATAFRAME
- Preserving DataFrame Modifications Across Options in a Streamlit Application
- Python Pandas getting hierarchy path till top management
- What is the best way to merge two dataframes that one of them has date ranges and the other one has date WITHOUT any shared columns?
- python pandas plot.bar something wrong
- Subsetting rows with sequence of values and identifying columns where sequence begins
- How to group rows by values to create new columns in Pandas DataFrame?
- How to write an R function to pivot the last n minutes?
- How can I change the groupby scope to find the first value that meets the conditions of a mask?
- Eliminate sub elements in a huge list of strings as long as no duplicates appear
- How to transfer object dataframe in sklearn.ensemble methods
- How can i fix this error ? Attempt to get argmax of an empty sequence
- How can I change the groupby column to find the first row that meets the conditions of a mask if the initial groupby failed to find it?
- How to iteratively create matrices/vectors from columns/unique row values of dataframe, and pass them to subsequent code?
- How to convert scraped HTML document to a dataframe?
- Replacing values on a dataframe row using a specific value as reference
Related Questions in HIVE
- Type Adapter for Offset in hive flutter
- HIVE Sql Date conversion
- How to set spark.executor.extraClassPath & spark.driver.extraClassPath in hive query without adding those in hive-site.xml
- Hive query on HUE shows different timestamp than programatically/on data
- descending order of data in hive using collect_set
- How to optimize writing to a large table in Hive/HDFS using Spark
- Spark SQL repartition before insert operation
- Alter datatype of complex type(array<struct>>) in hive
- SqlAlchemy connection to Hive using http thrift transport and basic auth
- Aggregate values into a new column while retaining the old column
- Is it possible to query MAPR hdfs/hive tables from Trino?
- Can we make a column having both partitioning and bucketing in hive?
- converting varchar(7) to decimal (7,5) in hive
- Extract all characters before numeric values in hive SQL
- Livy session to submit pyspark from HDFS
Related Questions in APACHE-SPARK-SQL
- Spark load all partions at once
- Joining 2 pyspark dataframes and continuing a running window sum and max
- Understanding least common type in databricks
- Insert selective columns into pyspark dataframe
- Dataframe won't save as anything - table, global temp view or temp view
- Spark TBLPROPERTIES to sql query?
- How to groupBy on two columns and work out avg total value for each grouped column using pyspark
- Spark SQL repartition before insert operation
- Convert 3 letter month column into a month number in Databricks SQL
- Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 - When reading table in SQL
- How to sort a PySpark dataframe rows by the order of a list?
- How to read csv files in dbfs using Spark SQL only?
- Handle different date formats in Pyspark
- Insert Overwrite partition data using Spark SQL on MINIO table
- update value in specific row by checking condition for another column values in pyspark
Related Questions in CLOUD
- I need an azure product that executes my intensive ffmpeg command then dies, and i only get charged for the delta. Any Tips?
- Does MS Word secretly upload my file to cloud?
- i was installing cloudstack and ended up in this error can anyone help me?
- Merge Azure mp4 blobs via API (Preferred Azure)
- What's the best practice to use OceanBase in cloud environment
- JSON representation of the current Terraform configuration
- I can't ssh to my instance, Connection refused
- Publish Vue.js + ASP.NET Core on Azure
- Why can CPU memory be specified and allocated during instance creation but not GPU memory on the cloud?
- AWS rekognition faces search
- SAP Cloud Connector
- Well isolated DB storage for each user
- how to upload multiple files and pictures to s3 while keeping the record in database?
- Error syncing Google Calendar, when i login with the account in the flutter project
- how to make public IP works on ec2 machine
Related Questions in SQL-DATA-WAREHOUSE
- Repeated PKs in Dimension Table - SSIS
- PostgreSQL as OLAP setup
- SCD TYPE 2 Implementation
- How to import datawarehouse to excel without using odbc?
- Azure Synapse Analytics - Dedicated Pool - Create user - Incorrect syntax near 'PASSWORD'
- How to set default time zone for SQL Warehouse in Databricks?
- I am using SSIS Vs to populate my fact table from staging to data warehouse but it is showing an error to the OLEDB destinations
- Invoice header and invoice line fact table extraction question
- SSAS "The Subscription identifier is invalid"
- Generate a number for a combination of columns in SQL Server
- Querying a Galaxy Schema in data warehouse
- Can we use spark.sql on any other database tables other than Hive tables?
- Dimensions inside FACT table?
- Many-to-many from relational design to dimensional design
- How to add a column based on the table which the data come from in SSIS?
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?
Yes, on Spark tables.
With push-down you can use against JDBC sources and HBASE etc. but then you may as well for JDBC sources use the SQL there for functionality and it runs on that hardware. Mostly you bring lower volume of data in to combine in Spark with Big Data sources and write less data to JDBC RDBMS's.