[jira] [Updated] (HIVE-2075) error in function count(distinct col)

2011-03-24 Thread Alexey Diomin (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Diomin updated HIVE-2075:


Description: 
select 
 N.cl1, 
 count(distinct N.cl2) as cl2count,
 N.cl3
from raw N
group by 
 N.cl1,
 N.cl2,
 N.cl3

not working on 0.7 (on 0.6 work correct), but count(N.cl2) work correct

  was:
select 
 N.cl1, 
 count(distinct N.cl2) as cl2count,
 N.cl3
from raw N
group by 
 N.cl1,
 N.cl2,
 N.cl3

not working on 0.7 (on 0.6 work correct), but count(distinct N.cl2) work correct


 error in function  count(distinct col)
 --

 Key: HIVE-2075
 URL: https://issues.apache.org/jira/browse/HIVE-2075
 Project: Hive
  Issue Type: Bug
  Components: Query Processor, Serializers/Deserializers
Affects Versions: 0.7.0
Reporter: Alexey Diomin

 select 
  N.cl1, 
  count(distinct N.cl2) as cl2count,
  N.cl3
 from raw N
 group by 
  N.cl1,
  N.cl2,
  N.cl3
 not working on 0.7 (on 0.6 work correct), but count(N.cl2) work correct

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Commented] (HIVE-2063) jdbc return only 1 collumn

2011-03-22 Thread Alexey Diomin (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13009623#comment-13009623
 ] 

Alexey Diomin commented on HIVE-2063:
-

wait
bug very interesting

reproducing on hadoop-0.20.2, but

on cloudera CDH3B4 bug not reproducing and apply patch break correct parsing 
input row,
as delimiter in input row is have code '1' (default)



 jdbc return only 1 collumn
 --

 Key: HIVE-2063
 URL: https://issues.apache.org/jira/browse/HIVE-2063
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Assignee: Alexey Diomin
Priority: Critical
 Attachments: HIVE-2063.patch, HIVE-2063.patch


 we not set separator for data and all data return in first columns and all 
 other fields set NULL
 addition we get WARNING: Missing fields! Expected 27 fields but only got 1! 
 Ignoring similar problems.
 it's regresion after HIVE-1378 
 bug:
 use delimiter '\t' for fields on server side
 use default delimiter with code '1' on client side

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] Updated: (HIVE-2063) jdbc return only 1 collumn

2011-03-19 Thread Alexey Diomin (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Diomin updated HIVE-2063:


Status: Patch Available  (was: Open)

 jdbc return only 1 collumn
 --

 Key: HIVE-2063
 URL: https://issues.apache.org/jira/browse/HIVE-2063
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Priority: Critical
 Attachments: HIVE-2063.patch, HIVE-2063.patch


 we not set separator for data and all data return in first columns and all 
 other fields set NULL
 addition we get WARNING: Missing fields! Expected 27 fields but only got 1! 
 Ignoring similar problems.
 it's regresion after HIVE-1378 
 bug:
 use delimiter '\t' for fields on server side
 use default delimiter with code '1' on client side

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] Updated: (HIVE-2063) jdbc return only 1 collumn

2011-03-19 Thread Alexey Diomin (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Diomin updated HIVE-2063:


Attachment: HIVE-2063.patch

 jdbc return only 1 collumn
 --

 Key: HIVE-2063
 URL: https://issues.apache.org/jira/browse/HIVE-2063
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Priority: Critical
 Attachments: HIVE-2063.patch, HIVE-2063.patch


 we not set separator for data and all data return in first columns and all 
 other fields set NULL
 addition we get WARNING: Missing fields! Expected 27 fields but only got 1! 
 Ignoring similar problems.
 it's regresion after HIVE-1378 
 bug:
 use delimiter '\t' for fields on server side
 use default delimiter with code '1' on client side

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] Created: (HIVE-2062) HivePreparedStatement.executeImmediate always throw exception

2011-03-18 Thread Alexey Diomin (JIRA)
HivePreparedStatement.executeImmediate always throw exception
-

 Key: HIVE-2062
 URL: https://issues.apache.org/jira/browse/HIVE-2062
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Priority: Critical


executeImmediate:

try {
  clearWarnings();
  resultSet = null;
  client.execute(sql);
}

but:
  public void clearWarnings() throws SQLException {
// TODO Auto-generated method stub
throw new SQLException(Method not supported);
  }

in result all calls executeQuery() for prepared statement return exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] Updated: (HIVE-2062) HivePreparedStatement.executeImmediate always throw exception

2011-03-18 Thread Alexey Diomin (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Diomin updated HIVE-2062:


Assignee: Alexey Diomin
  Status: Patch Available  (was: Open)

 HivePreparedStatement.executeImmediate always throw exception
 -

 Key: HIVE-2062
 URL: https://issues.apache.org/jira/browse/HIVE-2062
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Assignee: Alexey Diomin
Priority: Critical
 Attachments: HIVE-2062.patch


 executeImmediate:
 try {
   clearWarnings();
   resultSet = null;
   client.execute(sql);
 }
 but:
   public void clearWarnings() throws SQLException {
 // TODO Auto-generated method stub
 throw new SQLException(Method not supported);
   }
 in result all calls executeQuery() for prepared statement return exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] Updated: (HIVE-2062) HivePreparedStatement.executeImmediate always throw exception

2011-03-18 Thread Alexey Diomin (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Diomin updated HIVE-2062:


Attachment: HIVE-2062.patch

 HivePreparedStatement.executeImmediate always throw exception
 -

 Key: HIVE-2062
 URL: https://issues.apache.org/jira/browse/HIVE-2062
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Priority: Critical
 Attachments: HIVE-2062.patch


 executeImmediate:
 try {
   clearWarnings();
   resultSet = null;
   client.execute(sql);
 }
 but:
   public void clearWarnings() throws SQLException {
 // TODO Auto-generated method stub
 throw new SQLException(Method not supported);
   }
 in result all calls executeQuery() for prepared statement return exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] Created: (HIVE-2063) jdbc return only 1 collumn

2011-03-18 Thread Alexey Diomin (JIRA)
jdbc return only 1 collumn
--

 Key: HIVE-2063
 URL: https://issues.apache.org/jira/browse/HIVE-2063
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Priority: Critical
 Attachments: HIVE-2063.patch

we not set separator for data and all data return in first columns and all 
other fields set NULL

addition we get WARNING: Missing fields! Expected 27 fields but only got 1! 
Ignoring similar problems.

it's regresion after HIVE-1378 

bug:

use delimiter '\t' for fields on server side

use default delimiter with code '1' on client side

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] Updated: (HIVE-2063) jdbc return only 1 collumn

2011-03-18 Thread Alexey Diomin (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Diomin updated HIVE-2063:


Attachment: HIVE-2063.patch

 jdbc return only 1 collumn
 --

 Key: HIVE-2063
 URL: https://issues.apache.org/jira/browse/HIVE-2063
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Priority: Critical
 Attachments: HIVE-2063.patch


 we not set separator for data and all data return in first columns and all 
 other fields set NULL
 addition we get WARNING: Missing fields! Expected 27 fields but only got 1! 
 Ignoring similar problems.
 it's regresion after HIVE-1378 
 bug:
 use delimiter '\t' for fields on server side
 use default delimiter with code '1' on client side

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] Updated: (HIVE-2063) jdbc return only 1 collumn

2011-03-18 Thread Alexey Diomin (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-2063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alexey Diomin updated HIVE-2063:


Status: Patch Available  (was: Open)

 jdbc return only 1 collumn
 --

 Key: HIVE-2063
 URL: https://issues.apache.org/jira/browse/HIVE-2063
 Project: Hive
  Issue Type: Bug
  Components: JDBC
Affects Versions: 0.7.0
Reporter: Alexey Diomin
Priority: Critical
 Attachments: HIVE-2063.patch


 we not set separator for data and all data return in first columns and all 
 other fields set NULL
 addition we get WARNING: Missing fields! Expected 27 fields but only got 1! 
 Ignoring similar problems.
 it's regresion after HIVE-1378 
 bug:
 use delimiter '\t' for fields on server side
 use default delimiter with code '1' on client side

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira