python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - greenplum

Hive Double and Decimal value incorrect format

I am migrating the sql statement greenplum to HiveSQL supported with pyspark scripts. we are encounter the issues if the double or decimal value, the value getting changed while doing the sum of the d...
test-img

Developer KE

pyspark

hive

hiveql

greenplum

Votes: 0

Answers: 0

Writing from Spark into Greenplum Database using greenplum-connector-apache-spark-scala_2.12-2.1.0 - java.lang.IllegalStateException

Writing from Spark into Greenplum Database using greenplum-connector-apache-spark-scala_2.12-2.1.0 - java.lang.IllegalStateException Greenplum version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 buil...
test-img

Lawren Alex

java

apache-spark

pyspark

apache-spark-sql

greenplum

Votes: 0

Answers: 1

Latest Answer

I was able to get around this issue by downgrading Spark to 2.1.3.
test-img

L_gp

Unable to write spark dataframe to Greenplum table using spark-submit

I am reading a spark dataframe and trying to ingest the data in greenplum database table, but getting below error. It runs fine when I try the same code with spark-shell or zeppelin standalone server....
test-img

Ashutosh Sharma

apache-spark

greenplum

Votes: 0

Answers: 0

Greenplum turn strings into table

Everyone, how does GP turn the strings looking like a dictionary As below into the table with field names and values. I mean how to made it in SQL {"useCoupon":true,"useLevel":fals...
test-img

Jingwen NING

json

greenplum

Votes: 0

Answers: 1

Latest Answer

create table test(a json); insert into test(a) values('{"useCoupon":true,"useLevel":false,"usePoints":false,"useActivity" :false}'); insert into test(a) values(...
test-img

Anilkumar Nandala

Posts

Questions

Blogs

Jobs