[jira] [Closed] (CARBONDATA-335) Load data command options 'QUOTECHAR' perform unexpected behavior.
[
https://issues.apache.org/jira/browse/CARBONDATA-335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Harmeet Singh closed CARBONDATA-335.
Resolution: Fixed
FIXED
> Load data command options 'QUOTECHAR' perform unexpected behavior.
> ---
>
> Key: CARBONDATA-335
> URL: https://issues.apache.org/jira/browse/CARBONDATA-335
> Project: CarbonData
> Issue Type: Bug
>Reporter: Harmeet Singh
>
> Hey Team,
> I am using load data command with specific 'QUOTECHAR' option. But after
> loading the data, the behavior of quote character is not working as expected.
> Below is my example:
> create table one (name string, description string, salary double, age int,
> dob timestamp) stored by 'carbondata';
> CSV File Content >>
> name, description, salary, age, dob
> tammy, $my name$, 90, 22, 19/10/2019
> 0: jdbc:hive2://127.0.0.1:1> load data local inpath
> 'hdfs://localhost:54310/home/harmeet/dollarquote.csv' into table one
> OPTIONS('QUOTECHAR'="$");
> Results >>
> 0: jdbc:hive2://127.0.0.1:1> select * from one;
> Actual Output >>>
> ---+---+---+--+
> | tammy | $my name$ | NULL | 90.0
> | 22|
> ---+--+
>
> Expected Output >>>
> ---+---+---+--+
> | tammy | my name | NULL | 90.0
> | 22|
> ---+--+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (CARBONDATA-335) Load data command options 'QUOTECHAR' perform unexpected behavior.
Harmeet Singh created CARBONDATA-335:
Summary: Load data command options 'QUOTECHAR' perform unexpected
behavior.
Key: CARBONDATA-335
URL: https://issues.apache.org/jira/browse/CARBONDATA-335
Project: CarbonData
Issue Type: Bug
Reporter: Harmeet Singh
Hey Team,
I am using load data command with specific 'QUOTECHAR' option. But after
loading the data, the behavior of quote character is not working as expected.
Below is my example:
create table one (name string, description string, salary double, age int, dob
timestamp) stored by 'carbondata';
CSV File Content >>
name, description, salary, age, dob
tammy, $my name$, 90, 22, 19/10/2019
0: jdbc:hive2://127.0.0.1:1> load data local inpath
'hdfs://localhost:54310/home/harmeet/dollarquote.csv' into table one
OPTIONS('QUOTECHAR'="$");
Results >>
0: jdbc:hive2://127.0.0.1:1> select * from one;
Actual Output >>>
---+---+---+--+
| tammy | $my name$ | NULL | 90.0
| 22|
---+--+
Expected Output >>>
---+---+---+--+
| tammy | my name | NULL | 90.0 |
22|
---+--+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (CARBONDATA-327) Drop Daabase unexpected behaviour.
Harmeet Singh created CARBONDATA-327: Summary: Drop Daabase unexpected behaviour. Key: CARBONDATA-327 URL: https://issues.apache.org/jira/browse/CARBONDATA-327 Project: CarbonData Issue Type: Bug Reporter: Harmeet Singh Hey team, I am creating a database as below: 0: jdbc:hive2://127.0.0.1:1> create database Test; +-+--+ | result | +-+--+ +-+--+ After creating an database i am using that database using below command: 0: jdbc:hive2://127.0.0.1:1> use Test; +-+--+ | result | +-+--+ +-+--+ After That, i am drop the database as below: 0: jdbc:hive2://127.0.0.1:1> drop database test; +-+--+ | result | +-+--+ +-+--+ The database drop successfully. I am expecting, after that the carbon data automatically switch to the "default" database. But when i trying to execute command "show tables" the result return nothing as below : 0: jdbc:hive2://127.0.0.1:1> show tables; ++--+--+ | tableName | isTemporary | ++--+--+ ++--+--+ No rows selected (0.019 seconds) But my default database contains some table as below: 0: jdbc:hive2://127.0.0.1:1> use default; +-+--+ | result | +-+--+ +-+--+ No rows selected (0.024 seconds) 0: jdbc:hive2://127.0.0.1:1> show tables; ++--+--+ | tableName | isTemporary | ++--+--+ | one| false| | two| false| ++--+--+ 2 rows selected (0.013 seconds) If I am following all above step on Hive, Hive gave us an error on show tables after drop the database as below: hive> drop database test; OK Time taken: 0.628 seconds hive> show databases; OK default Time taken: 0.022 seconds, Fetched: 1 row(s) hive> show tables; FAILED: SemanticException [Error 10072]: Database does not exist: test -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (CARBONDATA-325) Create table with columns contains spaces in name.
Harmeet Singh created CARBONDATA-325: Summary: Create table with columns contains spaces in name. Key: CARBONDATA-325 URL: https://issues.apache.org/jira/browse/CARBONDATA-325 Project: CarbonData Issue Type: Bug Reporter: Harmeet Singh I want to create table, using columns that contains spaces. I am using Thrift Server and Beeline client for accessing carbon data. Whenever i am trying to create a table, and their columns name contains spaces i am getting an error. Below are the steps: Step 1: create table three (`first name` string, `age` int) stored by 'carbondata'; Whenever i am executing above query, i am getting below error: Error: org.apache.carbondata.spark.exception.MalformedCarbonCommandException: Unsupported data type : FieldSchema(name:first name, type:string, comment:null).getType (state=,code=0) The above error is pretending to be wrong data types are using. If I am removing `stored by 'carbondata'` from query, then this will work fine because it is run on Hive. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Harmeet Singh updated CARBONDATA-324: - Description: Using Thrift server and Beeling client, i am trying to create a table and load the data from CSV. My tables contains BigInt and Decimal Column types, After load the data using Load Data command, The BigInt and Decimal Column contains Null Value. Bellow are the steps: Step 1: > create database wednesday; > use wednesday; > CREATE TABLE one (id int, age iNt, name String, salary decimal, data bigInt, > weight double, dob timeStamp) STORED BY 'carbondata'; Step 2: Create a csv file which contains column values as below: id, age, name, salary, data, weight, dob 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 Step 3: Load the data from CSV file as below: > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO TABLE > one; Step 4: Select the data from table one, and BigInt and Decimal column contains Null value. > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
Harmeet Singh created CARBONDATA-324: Summary: Decimal and Bigint type columns contains Null, after load data Key: CARBONDATA-324 URL: https://issues.apache.org/jira/browse/CARBONDATA-324 Project: CarbonData Issue Type: Bug Reporter: Harmeet Singh -- This message was sent by Atlassian JIRA (v6.3.4#6332)
